Can anyone explain what the rows field on the sysindexes table is?
I have a table that has a primary key and two alternate indexes. After running sp_spaceused,@updateusage='True' against this table, when I check the sysindexes table, the rows count for the primary key and one of the alternate indexes is still set to zero.
This table does not have a clustered index.