All databases
sysstatistics contains one or more rows for each indexed column on a user table and for each partition. May also contain rows for unindexed column.
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 |
indid |
smallint |
Index ID of partition |
ststatus |
smallint |
Status bits for this statistics row; possible values vary according to the type of row. |
partitionid |
int |
Partition ID |
spare2 |
smallint |
For future use |
spare3 |
int |
For future use |
Unique clustered index csysstatistics on id, indid, partitionid, statid, colidarray, formatid, sequence
