Viewing 3 posts - 1 through 4 (of 4 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 what happened...
August 30, 2011 at 8:38 am
When I ran your test against a table with 18,399 rows I got these results:
if exists (select count(*) from A )
print 'here'...
August 30, 2011 at 8:04 am
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
Viewing 3 posts - 1 through 4 (of 4 total)