Descriptions of the results reported by sp_statistics .
Column |
Datatype |
Description |
---|---|---|
table_qualifier |
varchar(32) |
NULL. |
table_owner |
varchar(32) |
|
table_name |
varchar(32) |
NOT NULL. |
non_unique |
smallint |
NOT NULL.
|
index_qualifier |
varchar(32) |
|
index_name |
varchar(32) |
|
type |
smallint |
NOT NULL.
|
seq_in_index |
smallint |
NOT NULL. |
column_name |
varchar(32) |
NOT NULL. |
collation |
char(1) |
|
cardinality |
int |
Number of rows in the table or unique values in the index. |
pages |
int |
Number of pages to store the index or table. |