OK. Enough complexity in the subject line, here are the details
I have a table with many columns, two of them are ManagerId INT and DesignationCode VARCHAR(30), Now the following query
SELECT EmpId, EmpName FROM Employee WHERE DesignationCode='SWENG' AND ManagerId=3
A friend of mine has been told by an MVP that in this case integer comparison should be the first one in order and varchar should be the second to make it perform a lot better.
I tried googling for 15 min, found no evidence. Do you know of any performance suggestion ?
My friend says that his MVP friend says that SQL Server's engine is designed to process it faster this way. So the WHERE clause should be changed to WHERE ManagerId=3 AND DesignationCode='SWENG'
Do you guys know anything about it ?
View Complete Post