When Cardinality Statistics Go Stale

When Cardinality Statistics Go Stale

As you saw in When Cardinality Statistics Are Automatically Updated, cardinality statistics are automatically updated only in limited cases. Normal insert, update, and delete statements do not cause the statistics to be updated. This means that statistics can go stale. Stale statistics can slow your system down, because they worsen the accuracy of the optimizer's estimates of selectivity.