After create clustered index on the table, it takes about 2 seconds to execute select count statement against 17 million records. thanks.
1. MSSQL 2000 database has around 20 million records.
2. A simple select count statement takes about 15 minutes, although proper indexing has been...
Separate names with a comma.