Does OR clause suppress indexes in oracle?

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.

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.

With bitmap indexes, OR can use indexes and be very fast. Of course bitmap indexes have other drawbacks, depending on the situation. – Shannon Severance Sep 7 '10 at 22:12 find the example where or suppress the index.

– P Sharma Sep 26 '10 at 11:58.

I don't know what prompted you to ask this question but remember: "Full scans are not always evil; indexes are not always good" (Tom Kyte in "Effective Oracle by Design").

Pls, See my latest comments – P Sharma Sep 26 '10 at 12:00.

You can always do a UNION between both clauses and it will be easier to make indexes work select * from test2 where field1='field1=1' union select * from test2 where field3=1; Anyway I run your sample script and the index is being used.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.