What is the difference between
IF EXISTS(select 1 from t1)
and
IF EXISTS(select * from t1)
Is the first one more performant than the second?
Asked
Active
Viewed 374 times
0
-
4For all versions of SQL Server since 2000 these should evaluate the same, except you are referencing two diff. tables here. – JNK Apr 25 '14 at 19:09
-
Fixed the table names. Thanks. – Nestor Apr 25 '14 at 19:11
-
As @JNK says - they're the same. – Allan S. Hansen Apr 25 '14 at 19:56
-
No difference at all and you can acid test that by checking both query plan generated – jean Apr 30 '14 at 12:56