The systabstats table contains basic statistics for tables and indexes, for example:
Number of data pages for a table, or the number of leaf level pages for an index
Number of rows in the table
Height of the index
Average length of data rows and leaf rows
Number of forwarded and deleted rows
Number of empty pages
Statistics to increase the accuracy of I/O cost estimates, including cluster ratios, the number of pages that share an extent with an allocation page, and the number of OAM and allocation pages used for the object
Stopping points for the reorg command so that it can resume processing
systabstats stores one row for each table and nonclustered index in the database. The storage for clustered index information depends on the locking scheme for the table:
If the table is a data-only-locked table, systabstats stores an additional row for a clustered index.
If the table is an allpages-locked table, the data pages are treated as the leaf level of the index, so the systabstats entry for a clustered index is stored in the same row as the table data.
The indid column for clustered indexes on allpages-locked tables is always 1.
See the Adaptive Server Reference Manual for more information.
