SQL Server: Select in vs or?

ctrlShiftBryan_6161 0
Viewed 12162

Which is faster?

SELECT UserName
FROM dbo.UserTable
WHERE UserID in (1,3,4)

SELECT UserName
FROM dbo.UserTable
WHERE UserID = 1 
      OR UserID = 3
      OR UserID = 4
inline sql-server performance
3 Answers

Due to Sql Server's optimization of queries these will run at the same speed since they are logically equivalent.

i favor the IN syntax for brevity and readability though.

user_475500

Actually it is the same.

If you display the estimated execution plan you will see that it is performing the same action.

user_641320
Related