Hi,

 

Does the order of the conditions in a where clause make a difference?  I have a query that includes the columns that map to a unique index.  If I put the conditions containing these columns first in the where clause the query executes very quickly.  If I put other conditions first then the query takes over 30 seconds to run.  Is this expected or is this a bug?  If this is expected where could I have found this in the documentation?

 

Thanks,

 

John

Reply via email to