Re: Which of these selects is faster?

From: <silveys_at_my-dejanews.com>
Date: Wed, 14 Apr 1999 17:14:55 GMT
Message-ID: <7f2ie6$i8p$1@nnrp1.dejanews.com>

john0725_at_aol.com (John0725) wrote:
> 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.

Thanks, it's helpful to know that things are sufficiently complex that it seems oracle did not intend for users to predict the order of evaluation. (That sucks of course, and I'd like to see them fix it so that you could at least have the option to force a certain order.)

How did you come by this information? Trial and error? Oracle tech support? Actual documentation? Source code?

Thanks,

Scott

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 14 1999 - 12:14:55 CDT