> 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/optimizing-tables.md).

# Optimizing Tables

{% columns %}
{% column %}
{% content-ref url="/pages/vLg2ne69yn7hm4MLKrWQ" %}
[OPTIMIZE TABLE](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/optimize-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/OeI8fiTbg1tGg7zt3W1D" %}
[Defragmenting InnoDB Tablespaces](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/defragmenting-innodb-tablespaces.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
How to reclaim free space and defragment InnoDB tablespaces after deleting rows.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SvUstHKmAOvTI4YchaPb" %}
[Entity-Attribute-Value Implementation](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/entity-attribute-value-implementation.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Implementing the entity-attribute-value (EAV) model in MariaDB, and its trade-offs.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/lDdx1jdfQJKsQKPYSJDA" %}
[IP Range Table Performance](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/ip-range-table-performance.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Efficiently storing and querying large sets of non-overlapping ranges, such as IP address ranges.
{% endcolumn %}
{% endcolumns %}