Quiz · 5 questions
⚡ Indexes
B-tree, GIN, partial, expression — and when to skip them
Level 0Schema Seedling
0 XP0/86 lessons0/10 achievements
0/120 XP to next level120 XP to go0% complete
Quiz
01Which of these is NOT automatically given an index by PostgreSQL?
02What is the optimal column order for a composite index serving WHERE eq_col = X AND range_col > Y?
03Which index type is best for JSONB containment queries (col @> '{...}')?
04What does INCLUDE do in CREATE INDEX?
05Why are unused indexes a problem?
Comments 0
🔔 Reply notifications (sign in)Sign in — Please sign in to comment.
No comments yet — be the first.