Statistics – when you’ve got ‘em, and when they’re reasonable, life is good. But even when they’re good, Oracle’s optimizer can make some strange decisions, generating some hard to explain query plans. Histograms can be part of an effective solution, but they can also make life worse.
