Waiting for validation
Vous avez une requête qui doit filtrer 1M de lignes par user_id puis trier par created_at DESC et limiter à 10. Quel index est le plus efficace ?
Author: Bastien PELLETIER-GARNIERStatus: Waiting for validationQuestion not yet passed
0
Community EvaluationsNo one has reviewed this question yet, be the first!
2
Which command is used to remove all rows from a table without deleting the table itself in PostgreSQL?4
What type of index is primarily used for full-text search in PostgreSQL?5
What is the command to back up a database 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?3
Which PostgreSQL command changes the definition of a database object, like a table?10
Which command in PostgreSQL is used to delete a database?