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 Internals Manual
Preface and Legal Notice
A Guided Tour Of The MySQL Source Code
Coding Guidelines
Reusable Classes and Templates
Building MySQL Server with CMake
Plugins
Transaction Handling in the Server
The Optimizer
Code and Concepts
Definitions
The Optimizer Code
Primary Optimizations
Optimizing Constant Relations
Constant Propagation
Eliminating Dead Code
Folding of Constants
Constants and Constant Tables
Optimizing Joins
Determining the Join Type
Joins and Access Methods
The range Join Type
The index Join Type
The Index Merge Join Type
Transpositions
AND Relations
OR Relations
UNION Queries
NOT (<>) Relations
ORDER BY Clauses
GROUP BY and Related Conditions
Other Optimizations
NULLs Filtering for ref and eq_ref Access
Early NULLs Filtering
Late NULLs Filtering
Partitioning-Related Optimizations
Partition pruning
Partition selection
Tracing the Optimizer
Memory Allocation
Important Algorithms and Structures
File Formats
How MySQL Performs Different Selects
How MySQL Transforms Subqueries
MySQL Client/Server Protocol
X Protocol
Stored Programs
Prepared Statement and Stored Routine Re-Execution
Writing a Procedure
Replication
The Binary Log
MyISAM Storage Engine
InnoDB Storage Engine
Writing a Custom Storage Engine
Test Synchronization
Injecting Test Faults
How to Create Good Test Cases
Error Messages
MySQL Source Code Distribution
InnoDB Source Code Distribution
Index
MySQL Internals Manual
/
...
/
The Optimizer
/
Primary Optimizations
/
Optimizing Constant Relations
7.2.1 Optimizing Constant Relations
7.2.1.1 Constant Propagation
7.2.1.2 Eliminating Dead Code
7.2.1.3 Folding of Constants
7.2.1.4 Constants and Constant Tables
PREV
HOME
UP
NEXT