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
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')
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,
© Stack Overflow or respective owner