ANALYZE 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

Evaluates and stores index statistics for a table. The table remains locked during analysis.