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.