OPTIMIZE TABLE

This page is part of MariaDB's Documentation.

The parent of this page is: SQL Statements for MariaDB Xpand

Topics on this page:

• Overview

• USAGE

• DETAILS

  • SYNONYMS

  • SCHEMA

  • PARAMETERS

  • SKYSQL

  • PRIVILEGES

• EXAMPLES

• ERROR HANDLING

• FEATURE INTERACTION

• RESPONSES

• DIAGNOSIS

• ISO 9075:2016

• CHANGE HISTORY

• RELATED TOPICS

• EXTERNAL REFERENCES

Overview

Performs optimization on tablespaces, defragmenting files and updating InnoDB Full Text indexes.