2 Aug
2011
2 Aug
'11
7 a.m.
I have table with 81 887 010 rows. Select count from this table works fine, but I can't wait for the results of select count(distinct ...) from this table. Why can it be?
Distinct requires the table to be sorted to find them.
Can clustered index helps? Is it possible to create two or more clustered indexes on one table?