> 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/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-tuning.md).

# SQL Tuning

Techniques for analyzing and improving GridGain 9 SQL query performance, starting with the EXPLAIN command.

Analyze and improve the performance of your GridGain 9 SQL queries.

* [How to Improve Queries With EXPLAIN Command](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-tuning/using-explain.md) — read query execution plans, diagnose common performance issues, and tune your queries.
* [SQL Performance Tips](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-tuning/sql-performance-tips.md) — batch statements, avoid slow correlated subqueries, time requests, and drop cached plans.

{% columns %}
{% column %}
{% content-ref url="/pages/8sVOMalrp6wrlCZ3TVSF" %}
[Improving Queries with EXPLAIN](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-tuning/using-explain.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How to use the GridGain 9 SQL EXPLAIN command to read query execution plans, diagnose common performance issues, and improve query performance.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/GVXSaWODyi7kCaJbMzy4" %}
[SQL Performance Tips](/docs/gridgain/gridgain-9/tuning-and-troubleshooting/performance-tuning/sql-tuning/sql-performance-tips.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Ways to improve GridGain 9 SQL performance: batching statements, avoiding slow correlated subqueries, timing requests in the CLI, and dropping cached plans.
{% endcolumn %}
{% endcolumns %}