Query Tuning
11 practice items · needed by 1 role
Easy 1Medium 7Hard 3
Practice questions
- Finding slow MySQL querieseasy
- Composite index column ordermedium
- Reading an EXPLAIN ANALYZE planmedium
- Slow deep paginationmedium
- Which query to tune firstmedium
- Sort Method: external mergemedium
- Bad plan right after a bulk loadmedium
- Counting a huge table quicklymedium
- Partition pruninghard
- Prepared statement slows down laterhard
- Estimates wrong for city and zip codehard