REORG STATISTICS - Regenerate global statistics

You use REORG STATISTICS to re-generate global statistics on the distribution of values over the columns in an index. These statistics are used to optimize table accesses with search conditions and should be updated whenever extensive changes are made to the data.

The current authorization identifier must either be the owner of the schema to which the index belongs or must have the special privilege UTILITY for the database to which the index belongs.

---

REORG STATISTICS FOR INDEX index

---

index

Name of the index for which the statistics are to be re-generated.

You can qualify the name of the index with a database and schema name.

See also

CREATE INDEX