posted on Sunday, March 07, 2004 4:05 PM
by
taylorza
Thumbs up for Oracle Query optimizer
While installing Oracle on my notebook for a .NET project, it occurred to me to perform the same series of test I did for my earlier post on optimizing database queries. Wow, was I surprised, it appears that the Oracle query optimizer is automatically performing the transformation of the disjunctive normal form to conjunctive normal form. This is a real performance gain while maintaining the simplicity of the query.
Of course I am by no means an Oracle expert so any comments or opinions would be greatly appreciated. Does anyone have access to Yukon, I would really like to know how they are dealing with this.