0 Replies Latest reply: Sep 26, 2014 11:27 AM by Gonzalo Bianchi RSS

    are and clause evaluated all together or one at a time

    Gonzalo Bianchi

      Hi there..

       

      I'm trying to improve an script, and I was wondering if any one know how are And clause in a where evaluated.

       

      My examples where not very conclusive, so an inside word will be a lot better.

       

      What I have is a table with a lot of rows, and several conditions about them. I know that some conditions are more frequent that others, so I'm trying to understand if moving foward the conditions will be benefical at long term, or if there is a way to speed it up.