Oracle Scratchpad

March 11, 2008

Everything Changes

Filed under: CBO, Execution plans, Statistics — Jonathan Lewis @ 8:59 pm UTC Mar 11,2008

Sometimes you look at a change in the optimizer arithmetic and think “Why did that take so long to appear?” Here’s an example that’s probably going to cause a lot of heartache over the next couple of years as people go through the upgrade process. I have a query that looks like this:
(more…)

Blog at WordPress.com.