Posted by Daniel Wetzler on 02/16/06 10:33

Dear Erland and Joe,

thank you very much.
The select on sysindexes is a great advice and the best solution for
my
problem.

I tried another workaround yesterday :

I used the following statement :

select count(1) from table. (for tables with PRIMARY KEY in first
column)

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

Best regards and many thanks,

Daniel

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

[Reply to this message]