8.2.1 Optimizing SELECT Statements 8.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions 8.2.3 Optimizing INFORMATION_SCHEMA Queries 8.2.4 Optimizing Performance Schema Queries 8.2.5 Optimizing Data Change Statements 8.2.6 Optimizing Database Privileges 8.2.7 Other Optimization Tips