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 10 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
5
What is the command to back up a database in PostgreSQL?4
What type of index is primarily used for full-text search in PostgreSQL?6
What is the mechanism in PostgreSQL that ensures the integrity of transactions and supports concurrent processing?2
What does the ACID acronym stand for in the context of PostgreSQL transactions?10
Which command in PostgreSQL is used to delete a database?3
Which PostgreSQL command changes the definition of a database object, like a table?2
Which command is used to remove all rows from a table without deleting the table itself in PostgreSQL?