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
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2022 Oracle

  • Products
  • MySQL Database Service
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Consulting
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • Blogs
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2022 Oracle
Privacy / Do Not Sell My Info | Terms of Use | Trademark Policy |