Does OR clause suppress Indexes, If yes can someone provide appropriate example?
+8
A:
No, the use of the OR clause does not cause an index not to be used.
The OR clause only splinters the filtration decision path, and can be very costly for this depending on the complexity of the query & data involved.
OMG Ponies
2010-09-06 18:26:55
With bitmap indexes, OR can use indexes and be very fast. Of course bitmap indexes have other drawbacks, depending on the situation.
Shannon Severance
2010-09-07 22:12:44
Hi Kemp, find the example where or suppress the index.
P Sharma
2010-09-26 11:58:11