Analyze Table
Important
This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See ANALYZE TABLE.
ANALYZE TABLE [db_name.]table_name COMPUTE STATISTICS [analyze_option]
Collect statistics about the table that can be used by the query optimizer to find a better plan.
Table statistics
ANALYZE TABLE [db_name.]table_name COMPUTE STATISTICS [NOSCAN]
Collect only basic statistics for the table (number of rows, size in bytes).
NOSCAN
Collect only statistics that do not require scanning the whole table (that is, size in bytes).
Column statistics
ANALYZE TABLE [db_name.]table_name COMPUTE STATISTICS FOR COLUMNS col1 [, col2, ...]
Collect column statistics for the specified columns in addition to table statistics.
Tip
Use this command whenever possible because it collects more statistics so the optimizer can find better plans. Make sure to collect statistics for all columns used by the query.
See also:
Use Describe Table to inspect the existing statistics