how current is the info in sysindexes? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how current is the info in sysindexes?

can we dependably retrieve info like rows/rowcnt from it?
In sysindexes you can fin how many rows are in tables and index.
Column rows has this information. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
The information is not accurate at all times. Use DBCC UPDATEUSAGE for correcting the same before using the data. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Can use sp_spaceused with @updateusage flag for updating the same. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

]]>