Skip to content
Skills
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Home
/
Database Administrator
/
Questions
/
Query Tuning
Database Administrator
Query Tuning questions
11 questions on Query Tuning for database administrators, easiest first.
Easy
1
Finding slow MySQL queries
easy
Medium
7
Composite index column order
medium
Reading an EXPLAIN ANALYZE plan
medium
Slow deep pagination
medium
Which query to tune first
medium
Sort Method: external merge
medium
Bad plan right after a bulk load
medium
Counting a huge table quickly
medium
Hard
3
Partition pruning
hard
Prepared statement slows down later
hard
Estimates wrong for city and zip code
hard
