There is a theory stating that if ever anyone discovers exactly what the cost based optimizer does and how it works, it will instantly disappear and be replaced by something even more bizarre and inexplicable.

There is another theory that states this has already happened … twice.

Jonathan Lewis. Cost-Based Oracle Fundamentals