When counting number of rows in table it will take awful lot of time a sit has to scan through the table. For example I have a table with rows 18346967 and if I execute Select Count(*) from table1 It will take 32 seconds to give me the result. But if I run select rows from sysindexes where id = OBJECT_ID(table1) and indid < 2 It will take less than one second. However problem you have this with you cant get the group count. You can only use when you are counting all the records.