Index & Query Tuning
Learn Index & Query Tuning (MySQL Performance Tuning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Index and query tuning means making the optimizer read fewer rows: add the right indexes, write predicates that can use them, and verify the plan with EXPLAIN .