Oracle Optimizer Statistics, Demystified

The optimizer doesn't guess. It calculates — and every number in that calculation comes from statistics you either gathered on purpose or left to rot. That's the part the "the optimizer is dumb" stori