Posted by Daniel Wetzler on 02/15/06 16:45
Dear MS SQL Experts,
I have to get the number of datasets within several tables in my MSSQL
2000 SP4 database.
Beyond these tables is one table with about 13 million entries.
If I perform a "select count(*) from table" it takes about 1-2 min to
perform that task.
Since I know other databases like MySQL which take less than 1 sec for
the same task
I'm wondering whether I have a bug in my software or whether there are
other mechanisms to get the number of datasets for tables or the number
of datasets within the whole database.
Can you give me some hints ?
Best regards,
Daniel Wetzler
[Back to original message]
|