Skip to content
Skills
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Home
/
Database Administrator
/
Questions
/
Indexing
Database Administrator
Indexing questions
12 questions on Indexing for database administrators, easiest first.
Easy
1
When a B-tree index helps
easy
Medium
8
Composite index column order
medium
Covering index
medium
Slow deep pagination
medium
Adding an index on a live table
medium
Deleting a customer takes seconds
medium
Indexing only pending rows
medium
Searching inside text
medium
Fast JSONB filters
medium
Hard
3
Index ignored because of a function
hard
Index-only scan still reads the table
hard
Random UUID keys slow down inserts
hard
