ANALYZE
ANALYZE
Name
ANALYZE
Description
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 formatdb_name.table_name
.column_name
: The specified target column. It must be an existing column intable_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.
Example
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;
Keywords
ANALYZE