Oracle DBA

Indexing & Optimizer Statistics

Question

Queries on the latest day's rows get tiny cardinality estimates, but the table isn't flagged stale; what should change?

Answer

The recorded column high value lags the newest data, so the optimizer underestimates out-of-range predicates. Lower the table's STALE_PERCENT preference or gather statistics after each load so recent values are captured. Applies to all Oracle Database editions.

This is 9 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples