are and clause evaluated all together or one at a time
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.