Home Forums SQL Server 2005 T-SQL (SS2K5) SELECT * versus SELECT 1 when using EXISTS RE: SELECT * versus SELECT 1 when using EXISTS
Adam Angelini
SSCrazy Eights
Points: 8548
More actions
September 11, 2009 at 12:58 pm
#1052515
I've seen arguments both ways, but I always recommend trying both solutions yourself, checking query plans, and deciding which is better in your situation. I suspect both will produce the same plan, but it's always best to test it out.