Why Cardinality Estimates Go Wrong: An Oracle Optimizer Lab with Skewed Data

Every Oracle DBA has had this conversation with a developer: "the query ran fine yesterday, it's slow today, nothing changed." Nine times out of ten, when you pull the plan, the root cause is the same