> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning.md).

# Query Tuning

- [Collecting Statistics with ANALYZE TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/collect-statistics-with-analyze-table-for-mariadb-enterprise-columnstore.md): Optimizer statistics collected with ANALYZE TABLE in MariaDB Enterprise ColumnStore 6 enable circular inner joins and help ExeMgr choose better join orders for analytical queries.
- [Query Tuning Recommendations](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-tuning-recommendations-for-mariadb-enterprise-columnstore.md): Query tuning recommendations for MariaDB ColumnStore: select only required columns, avoid large single-threaded ORDER BY and LIMIT sorts, and follow analytical best practices.
- [Query Plans and Optimizer Trace](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-plans-and-optimizer-trace.md): MariaDB ColumnStore's query plans and Optimizer Trace show how analytical queries run in parallel across its distributed, columnar architecture, aiding performance tuning.
- [Execution Plan (CSEP)](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-plans-and-optimizer-trace/columnstore-execution-plan-csep-for-mariadb-enterprise-columnstore.md): The ColumnStore Execution Plan (CSEP) is the internal query-plan representation in MariaDB ColumnStore, generated from SELECT\_LEX and viewable through calSetTrace.
- [Job Steps](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-plans-and-optimizer-trace/job-steps-for-mariadb-enterprise-columnstore.md): Job steps in MariaDB ColumnStore: ExeMgr translates the CSEP into a job list of distributed and multi-threaded steps (BPS, CES, etc.) for parallel query execution across nodes.
- [Query Statistics for MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/high-availability/columnstore-query-tuning/query-statistics-for-mariadb-enterprise-columnstore.md): Query statistics log MariaDB ColumnStore execution metrics (memory, I/O, cache) to infinidb\_querystats; disabled by default and exposed via SHOW WARNINGS and calGetStats().