Re: Performance on queries with a lot of AND / OR operators

Maybe what you read as vague request is more a general request?

I thought it was quite clear - oracle version aside (version 8i). What difference does it make what code optimizer I use when my question was on SQL? Then say that an IN operator takes less performance then an OR operator. (was very helpful for me)
My question was really quite simple, and if you don't want to answer then don't. I am not looking for crystal balls, I just wanted to know the impact on a database if I would do a query like:

select x
from y
where field1 like 'a'

   and field2 like 'b'
   and field3 like 'c'

versus

select x
from y
where field1 like 'a'

    and (field2 like 'b' or field2 like 'c')     and (field4 like 'd' or (field5 like 'e' and field6 like 'f'))

I am sorry, but I was really not anticipating to be so barked at, it was just an honest question.

Cheers,
Aritha. Received on Tue Aug 23 2005 - 01:39:49 CDT