Section 8.2.1.18, “DISTINCT Optimization” Section 8.2.1.5, “Engine Condition Pushdown Optimization” Section 8.8.2, “EXPLAIN Output Format” Section 13.8.2, “EXPLAIN Statement” Section 8.8.3, “Extended EXPLAIN Output Format” Section 12.18.3, “Functions That Search JSON Values” Section 8.2.1.17, “GROUP BY Optimization” Section 8.2.1.4, “Hash Join Optimization” Section 8.2.1.6, “Index Condition Pushdown Optimization” Section 8.9.4, “Index Hints” Section 8.2.1.3, “Index Merge Optimization” Section 8.4.4, “Internal Temporary Table Use in MySQL” Section 26.1, “Introduction” Section 8.3.12, “Invisible Indexes” Section 8.2.1.15, “IS NULL Optimization” Section 8.2.1.19, “LIMIT Query Optimization” Section 12.24, “Miscellaneous Functions” Section 8.2.1.11, “Multi-Range Read Optimization” Section 4.5.1.6, “mysql Client Tips” Chapter 27,  MySQL Performance Schema NDB Cluster Status Variables NDB Cluster System Variables Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection” Section 24.3.5, “Obtaining Information About Partitions” Section 8.9.3, “Optimizer Hints” Section 8.9.6, “Optimizer Statistics” Section 8.3.11, “Optimizer Use of Generated Column Indexes” Section B.3.5, “Optimizer-Related Issues” Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization” Section 8.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations” Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries” Section 8.2.4, “Optimizing Performance Schema Queries” Section 8.8.1, “Optimizing Queries with EXPLAIN” Section 8.2.1, “Optimizing SELECT Statements” Section 8.2.2.2, “Optimizing Subqueries with Materialization” Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy” Section 8.2.1.16, “ORDER BY Optimization” Section 24.4, “Partition Pruning” Section 6.2.2, “Privileges Provided by MySQL” Section 8.2.1.2, “Range Optimization” Section 25.8, “Restrictions on Stored Programs” Section 13.1.20.9, “Secondary Indexes and Generated Columns” Section 13.2.10, “SELECT Statement” Section 13.7.7.42, “SHOW WARNINGS Statement” Section B.3.4.7, “Solving Problems with No Matching Rows” Section 27.12.20.3, “Statement Summary Tables” Section 8.9.2, “Switchable Optimizations” Section 1.2.2, “The Main Features of MySQL” Section 28.4.4.22, “The ps_trace_statement_digest() Procedure” Section 8.8, “Understanding the Query Execution Plan” Section 8.3.10, “Use of Index Extensions” Section 5.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld” Section 11.4.11, “Using Spatial Indexes” 5924