Re: Where clause ordering

For those of you who have been following this thread:

I have now got back to the Oracle 7.1.6, and it does seem to optimise the following statement differently from 7.1.3:  

       select count(*) from lookups
       where
               to_number(value) = 0
       and     class in (123,456);

(NB No indexes involved here).

7.1.6 evaluates the to_number() first, then checks the class. 7.1.3 checks the class then evaluates the to_number().

-- 
Jonathan Lewis