Use the ANALYZE TABLE statement to update table statistics.

mysql> ANALYZE TABLE tbl_name;

For example:

mysql> ANALYZE TABLE airline;

The statement returns a table similar to the following:

+---------+--------------------------+----------+----------+
| Table   | Op                       | Msg_type | Msg_text |
+---------+--------------------------+----------+----------+
| airline | analyze                  | status   | OK       |
| airline | analyze secondary engine | status   | OK       |
+---------+--------------------------+----------+----------+

The details of columns available in this table are described in ANALYZE TABLE Output.

When you run the ANALYZE TABLE statement for a table loaded in MySQL HeatWave, the analysis is performed on MySQL HeatWave. The output contains an additional row showing the results of the analysis on the secondary engine.

The ANALYZE TABLE statement updates the Advanced Cardinality Estimation (ACE) statistics for tables loaded in MySQL HeatWave. ACE statistics models are a more powerful version of column histograms and are used by secondary engine to perform query optimization.

If the enable_secondary_engine_statistics system variable is set to ON, the secondary engine builds an ACE statistics model for a table when the ANALYZE TABLE statement is run on the table with or without the UPDATE HISTOGRAM clause.

The secondary engine does not build an ACE statistics model for a table in the following scenarios:

When the secondary engine creates the ACE statistics model, the ACE_MODEL column is updated in the performance schema table rpd_tables.