T/SQL Efficiency and Order of Execution
- by Kyle Rozendo
Hi All,
In regards to the order of execution of statements in SQL, is there any difference between the following performance wise?
SELECT * FROM Persons
WHERE UserType = 'Manager' AND LastName IN ('Hansen','Pettersen')
And:
SELECT * FROM Persons
WHERE LastName IN ('Hansen','Pettersen') AND UserType = 'Manager'
If there is any difference, is there perhaps a link etc. that you may have where one can learn more about this?
Thanks a ton,
Kyle