Hi, Joshi, The only hint that may affect the evaluation order in the WHERE clause is ORDERED_PREDICATES. But I don't know who actually got it to work. The chapter "Optimizer Hints" in Performance Tuning Guide talks about it. It also says if you don't have this hint, there's a certain order in which Oracle evaluates predicates in the WHERE clause. Not sure if that's true. You can try switching the predicates around and look at the execution plan for each.
Documentation is wrong in saying that you should be put that hint in the WHERE clause. Yong Huang --- A Joshi <[EMAIL PROTECTED]> wrote: > Hi, > In a SQL statement I want a certain where clause to be done first. Is it > enough to list it first as follows or do I (and can I) do something else to > make it get checked first before other WHERE/AND clause are looked at. Thanks > : > > SELECT emp_id FROM emp > WHERE select_sen_emp_chk_first = 'Y' > AND dept = :dept > AND salary > :min_sal __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
