T/SQL Efficiency and Order of Execution

Posted by Kyle Rozendo on Stack Overflow See other posts from Stack Overflow or by Kyle Rozendo
Published on 2010-04-09T13:06:02Z Indexed on 2010/04/09 13:13 UTC
Read the original article Hit count: 395

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about tsql