When cardinality statistics are automatically updated

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.