ANALYZE

ANALYZE

This statement is used to collect statistical information for various columns.

ANALYZE < TABLE | DATABASE table_name | db_name > 
    [ (column_name [, ...]) ]
    [ [ WITH SYNC ] [ WITH SAMPLE PERCENT | ROWS ] ];

table_name: The specified target table. It can be in the format db_name.table_name.
column_name: The specified target column. It must be an existing column in table_name. You can specify multiple column names separated by commas.
sync: Collect statistics synchronously. Returns after collection. If not specified, it executes asynchronously and returns a JOB ID.
sample percent | rows: Collect statistics with sampling. You can specify a sampling percentage or a number of sampling rows.

Collect statistical data for a table with a 10% sampling rate:

ANALYZE TABLE lineitem WITH SAMPLE PERCENT 10;

Collect statistical data for a table with a sample of 100,000 rows:

ANALYZE TABLE lineitem WITH SAMPLE ROWS 100000;

ANALYZE