As you saw in
Statistics are likely to be stale if the number of distinct values in an
index has changed significantly. This can happen often or rarely, depending on
the nature of the column being indexed. You can refresh cardinality statistics
by calling the procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS. For information
about this procedure, see the