circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Watch 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 morning

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guides
  • tvServer Usage
  • gearServer Management
  • shield-halvedSecurity
  • house-blankArchitecture
  • wrenchClients & Utilities
  • chart-mixedHA & Performance
    • Optimization and Tuning
      • Buffers, Caches and Threads
      • MariaDB Internal Optimizations
      • Operating System Optimizations
      • Optimization and Indexes
      • Optimizer Hints
      • Compression
      • Optimizing Data Structure
      • Optimizing Tables
      • Optimizing Queries
      • Query Optimizer
        • 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 Trace
      • System and Status Variables
    • Replication
    • Benchmarking
    • MariaDB Memory Allocation
    • Hardware Optimization
    • Connection Redirection Mechanism in the MariaDB Client/Server Protocol
  • paperclipReference
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?