Viewing 3 posts - 1 through 3 (of 3 total)
@heb1014 (Great Reference btw!) 🙂
I haven't used the SET STATISTICS much, so I hope I did it correctly. Running it with TIME made sense, but I don't understand...
August 30, 2011 at 8:38 am
#1375039
@heb1014:
When I ran your test against a table with 18,399 rows I got these results:
if exists (select count(*) from A )
...
August 30, 2011 at 8:04 am
#1375022
I agree with what you wrote regarding the use of EXISTS being more efficient than using COUNT.
To take it one notch higher, I always use
EXISTS (select TOP 1 PrimaryKeyField...
August 30, 2011 at 6:33 am
#1374927