For the following operations that you perform on a table, automatically
creates statistics. Those operations are:
- (new index only) When you create a new index on an existing non-empty
table.
- (new backing indexes only) When you add a primary key, unique, or foreign
key constraint to an existing non-empty table.
For other operations, automatically updates statistics for
the table and all indexes on the table if they are already exist. Those operations
are:
- (all indexes) When you execute SYSCS_UTIL.SYSCS_COMPRESS_TABLE.
- (index only) When you drop a column that is part of a table's index;
the statistics for the affected index are dropped, and statistics for the
other indexes on the table are updated.