X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2023 MariaDB. All rights reserved.

  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Services
  • Pricing
  • Resources
  • About Us
  • Download
Knowledge Base » Training & Tutorials » Advanced MariaDB Articles » Development Articles » MariaDB Internals Documentation » Query Optimizer » Optimizer Trace
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here
Product Versions

Optimizer Trace

  • Optimizer Trace Overview

    Produces a JSON trace with decision info taken by the optimizer during the optimization phase.
  • Optimizer Trace Guide

    Guide to the structured log file showing what actions were taken by the query optimizer.
  • Basic Optimizer Trace Example

    MariaDB> set optimizer_trace=’enabled=on’; MariaDB> select * from t1 where a<10; MariaDB> s
  • Optimizer Trace for Developers

    This article describes guidelines for what/how to write to Optimizer Trace ...
  • Optimizer Trace Resources

    Optimizer Trace Walkthrough talk at MariaDB Fest 2020: https://mariadb.org/...
  • ← Optimizations for Derived Tables
  • ↑ Query Optimizer ↑
  • Statistics for Optimizing Queries →
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ Query Optimizer ↑
  • Optimization Strategies
  • Optimizations for Derived Tables
  • Optimizer Trace
  • Statistics for Optimizing Queries
  • Table Elimination
  • Block-Based Join Algorithms
  • Condition Selectivity Computation Internals
  • Extended Keys
  • MIN/MAX optimization
  • Optimizer Debugging With GDB
  • Rowid Filtering Optimization
  • The Optimizer Cost Model from MariaDB 11.0
Products
  • MariaDB Platform
  • MariaDB SkySQL
  • Pricing
  • Download MariaDB
Services
  • Remote DBA
  • SkyDBA
  • Enterprise Architect
  • Technical Support
  • Migration Practice
  • Consulting
  • Training
Resources
  • Documentation
  • Developers
  • Blog
  • Support
  • OpenWorks
  • Customer Stories
  • Events
  • MariaDB Roadshow
About
  • Contact
  • Leadership
  • Partners
  • Newsroom
  • Investors
  • Careers
  • Trust Center
  • Vulnerability Reporting
Contact

Subscribe to our newsletter!

  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2023 MariaDB. All rights reserved.