Select count(*)


Today I was reading(I always read Paul Randal).

I learned that whenever you query select count(*) it will select the the best plan… as

if no index —no option –table scan

INDEX: choose the smallest possible index(if has multiple index) to achieve the lowest I/O cost.

you can also test this with

set statistics io on



This entry was posted in What I learned today and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.