All databases
sysstatistics contains one or more rows for each indexed column on a user table. May also contain rows for unindexed column. Uses datarow locking.
The columns for sysstatistics are:
Name |
Datatype |
Description |
|---|---|---|
statid |
smallint |
Reserved |
id |
int |
Object ID of table |
sequence |
int |
Sequence number if multiple rows are required for this set of statistics |
moddate |
datetime |
Date this row was last modified |
formatid |
tinyint |
Type of statistics represented by this row |
usedcount |
tinyint |
Number of fields c0 to c79 used in this row |
colidarray |
varbinary(100) |
An ordered list of column IDs |
c0...c79 |
varbinary(255) |
Statistical data |
Unique clustered index On id, statid, colidarray, formatid, sequence
