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!
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?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?5
What is the command to back up a database in PostgreSQL?2
What does the ACID acronym stand for in the context of PostgreSQL transactions?2
Which command is used to remove all rows from a table without deleting the table itself in PostgreSQL?