Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which of these selects is faster?
If the where clause has ANDs then it is evaluated from the end of the query
towards the beginning, but if it has ORs it is evaluated starting closest to
the FROM clause and working its way downward.
I have read that you want to order your where clause so that the first thing it comes across will eliminate the most rows, but you also have to weigh in what fields will allow the use of indexes.
--John Received on Tue Apr 13 1999 - 23:26:03 CDT