The SYSCS_UTIL.SYSCS_UPDATE_STATISTICS system procedure
updates the cardinality statistics, or creates the statistics if they
do not exist, for the index that you specify or for all of the indexes
on a table.
Once statistics have been created, they cannot be dropped and should be maintained. It is a good idea to call the SYSCS_UTIL.SYSCS_UPDATE_STATISTICS procedure when the number of distinct values in an index is likely to have changed significantly.
For more information on cardinality statistics,
see "Working with cardinality statistics" in the
In the following example, the system procedure updates statistics for the index PAY_DESC on the SAMP.EMPLOYEE table:
In the following example,