Skip to main content

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 .

More lessons in MySQL Performance Tuning