> 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/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations.md).

# MariaDB Internal Optimizations

{% columns %}
{% column %}
{% content-ref url="/pages/m4JT1mli0VSqdPTFx73y" %}
[Fair Choice Between Range and Index\_merge Optimizations](/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/fair-choice-between-range-and-index_merge-optimizations.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How the optimizer chooses fairly between the range and index\_merge access methods.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/hMEPaD4YeBuN8hxrl3zQ" %}
[Multi Range Read Optimization](/docs/server/ha-and-performance/optimization-and-tuning/mariadb-internal-optimizations/multi-range-read-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The Multi-Range Read (MRR) optimization, which improves performance for I/O-bound queries scanning many rows.
{% endcolumn %}
{% endcolumns %}