Easy
You have a query that must filter 1M rows by user_id and then sort by created_at DESC and limit to 10. Which index is the most efficient?
Author: Bastien PELLETIER-GARNIERStatus: PublishedQuestion passed 3 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
10
Which command in PostgreSQL is used to delete a database?4
What type of index is primarily used for full-text search in PostgreSQL?2
What does the ACID acronym stand for in the context of PostgreSQL transactions?6
What is the mechanism in PostgreSQL that ensures the integrity of transactions and supports concurrent processing?5
What is the command to back up a database in PostgreSQL?2
Which command is used to remove all rows from a table without deleting the table itself in PostgreSQL?3
Which PostgreSQL command changes the definition of a database object, like a table?