Posted by Erland Sommarskog on 02/17/06 00:18

Daniel Wetzler (Daniel.Wetzler@sig.biz) writes:
> I used the following statement :
>
> select count(1) from table. (for tables with PRIMARY KEY in first
> column)

COUNT(1) or COUNT(*) makes no difference.

> It seems that MS SQL has to load the whole table information if I say
> count(*).

As I said, if there is no non-clustered table, there is no better
option than to scan all data pages.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server 2000 conferences
• Prev in forum: Re: Select command with multiple tables
• Thread view: Re: very slow query (select count(*) from table)

[Reply to this message]