Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
|
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
I've seen many cases where Oracle decided to use and access and a filter predicate on the exact same column predicate. I don't fully understand why this is done, I caulk it up to the optimizer being paranoid. I have a recollection that Johnathon Lewis has something about this in his book, but I can't seem to find it right now. I'll update this once I find out more on this.
|
Powered by FogBugz