GilaMonster (10/11/2012)
IN is not an expensive operation. For matching rows, it's cheaper than join.Moving a filter from a join to the where when you have an outer join changes the logic of the query and likely the results.
Interesting about the IN, I've always found them to be more expensive than Joins and so avoided them.
Mentally noted about the Outer Join and filter moving, does it have the same effect on an Inner Join.
_________________________________________________________________________
SSC Guide to Posting and Best Practices