Skip to Main Content
The world's most popular open source database
Contact MySQL  | 
Login  |  Register
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL 8.0 Reference Manual
  • Preface and Legal Notices
  • General Information
  • Installing MySQL
  • Upgrading MySQL
  • Downgrading MySQL
  • Tutorial
  • MySQL Programs
  • MySQL Server Administration
  • Security
  • Backup and Recovery
  • Optimization
    • Optimization Overview
    • Optimizing SQL Statements
      • Optimizing SELECT Statements
        • WHERE Clause Optimization
        • Range Optimization
        • Index Merge Optimization
        • Hash Join Optimization
        • Engine Condition Pushdown Optimization
        • Index Condition Pushdown Optimization
        • Nested-Loop Join Algorithms
        • Nested Join Optimization
        • Outer Join Optimization
        • Outer Join Simplification
        • Multi-Range Read Optimization
        • Block Nested-Loop and Batched Key Access Joins
        • Condition Filtering
        • Constant-Folding Optimization
        • IS NULL Optimization
        • ORDER BY Optimization
        • GROUP BY Optimization
        • DISTINCT Optimization
        • LIMIT Query Optimization
        • Function Call Optimization
        • Window Function Optimization
        • Row Constructor Expression Optimization
        • Avoiding Full Table Scans
      • Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions
        • Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations
        • Optimizing Subqueries with Materialization
        • Optimizing Subqueries with the EXISTS Strategy
        • Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization
        • Derived Condition Pushdown Optimization
      • Optimizing INFORMATION_SCHEMA Queries