When you have a query like this...
Select * from Table1 WHERE a=1 and b=2 and c IN (5,6,7,8,9,0,1,2,3,4)
How does SQL process that?
I am trying to figure out if there is any real performance difference between the IN ( ) clause and a join to a temp table.
View Complete Post