Estimating the cost of a plan
Table statistics
Optimizers will guess if necessary, but will use statistics about
column data distributions if available.
analyze TABLE_NAME
- Gathers statistics on each column of the table.
- If table name is omitted, analyze every table in the database.
- Always a manual operation. Statistics are not updated
automatically.
|