Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

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




No comments.

Leave a Comment

Please register or log in to leave a comment.