8.2.1.2 Range Optimization
8.2.1.3 Index Merge Optimization
8.2.1.4 Hash Join Optimization
8.2.1.5 Engine Condition Pushdown Optimization
8.2.1.6 Index Condition Pushdown Optimization
8.2.1.7 Nested-Loop Join Algorithms
8.2.1.8 Nested Join Optimization
8.2.1.9 Outer Join Optimization
8.2.1.10 Outer Join Simplification
8.2.1.11 Multi-Range Read Optimization
8.2.1.12 Block Nested-Loop and Batched Key Access Joins
8.2.1.13 Condition Filtering
8.2.1.14 Constant-Folding Optimization
8.2.1.15 IS NULL Optimization
8.2.1.20 Function Call Optimization
8.2.1.21 Window Function Optimization
8.2.1.22 Row Constructor Expression Optimization
8.2.1.23 Avoiding Full Table Scans