circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Register Nowarrow-up-right
LogoLogo
search
Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good afternoon

I'm here to help you with the docs.

Ctrli
AI Based on your contextquestion-circle
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guideschevron-right
  • tvServer Usagechevron-right
  • gearServer Managementchevron-right
  • shield-halvedSecuritychevron-right
  • house-blankArchitecturechevron-right
  • wrenchClients & Utilitieschevron-right
  • chart-mixedHA & Performancechevron-right
    • Optimization and Tuningchevron-right
      • Buffers, Caches and Threadschevron-right
      • MariaDB Internal Optimizationschevron-right
      • Operating System Optimizationschevron-right
      • Optimization and Indexeschevron-right
      • Optimizer Hintschevron-right
      • Compressionchevron-right
      • Optimizing Data Structurechevron-right
      • Optimizing Tableschevron-right
      • Optimizing Querieschevron-right
      • Query Optimizerchevron-right
        • Block-Based Join Algorithms
        • Condition Selectivity Computation Internals
        • Extended Keys
        • MIN/MAX optimization
        • Notes When an Index Cannot Be Used
        • Optimizer Debugging With GDB
        • Optimizer Development
        • optimizer_max_sel_arg_weight
        • Range Optimizer
        • The Optimizer Cost Model from MariaDB 11.0
        • Optimizer Tracechevron-right
      • System and Status Variableschevron-right
    • Replicationchevron-right
    • Benchmarking
    • MariaDB Memory Allocation
    • Hardware Optimization
    • Connection Redirection Mechanism in the MariaDB Client/Server Protocol
  • paperclipReferencechevron-right
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. chart-mixedHA & Performancechevron-right
  2. Optimization and Tuning

Query Optimizer

Delve into the MariaDB Server query optimizer. This section provides internal documentation on how queries are parsed, optimized, and executed for maximum efficiency and performance.

Block-Based Join Algorithmschevron-rightCondition Selectivity Computation Internalschevron-rightExtended Keyschevron-rightMIN/MAX optimizationchevron-rightNotes When an Index Cannot Be Usedchevron-rightOptimizer Debugging With GDBchevron-rightOptimizer Developmentchevron-rightoptimizer_max_sel_arg_weightchevron-rightRange Optimizerchevron-rightThe Optimizer Cost Model from MariaDB 11.0chevron-rightOptimizer Tracechevron-right
PreviousWhat is Table Elimination?chevron-leftNextBlock-Based Join Algorithmschevron-right

Last updated 1 month ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2026 MariaDB. All rights reserved.

Was this helpful?