Results Set for sp_statistics

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.
  • 0 – unique.
  • 1 – nonunique.

index_qualifier

varchar(32)

 

index_name

varchar(32)

 

type

smallint

NOT NULL.
  • 0 – clustered.
  • 2 – hashed.
  • 3 – other.

seq_in_index

smallint

NOT NULL.

column_name

varchar(32)

NOT NULL.

collation

char(1)

  • A – ascending.
  • D – descending.
  • NULL – not applicable.

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.