[dba-VB] SQL Server WHERE Clause order

jwcolby jwcolby at colbyconsulting.com
Mon May 5 08:06:01 CDT 2008


Does it make any difference in SQL Server the order of the WHERE clause 
items.  For example:

WHERE (LastName IS NOT NULL) AND (AGE > 30)

vs

WHERE (AGE > 30) AND (LastName IS NOT NULL)



-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-VB mailing list