SQL - Does the order of the where clause have an effect on performance?
920906Jun 29 2012 — edited Jun 29 2012Does the order of the where clause have an effect on performance? Or is there a way to force Oracle to use a certain where clause first?
I'm thinking of a condition where the first line will limit a large result set by 98%.
While the next 4 lines reduces the query by only 1%.
So I want to force the plan to use the first line(shrink results) before trying the other lines which have complex logic and are slower.
So is there a way to control it? Does oracle just have a mind of it's own?
Please advise.