The SQLSTATISTICS view contains statistic information on a table. The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
TABLE_CAT | VARCHAR(128) | Relational database name |
TABLE_SCHEM | VARCHAR(128) | Name of the SQL schema of the table. |
TABLE_NAME | VARCHAR(128) | Name of the table. |
NON_UNIQUE | SMALLINT
Nullable |
Indicates whether an index prohibits duplicate
keys on the table.
Contains the null value if the TYPE is 0. |
INDEX_QUALIFIER | VARCHAR(128)
Nullable |
Name of the schema of the index.
Contains the null value if the TYPE is 0. |
INDEX_NAME | VARCHAR(128)
Nullable |
Name of the index.
Contains the null value if the TYPE is 0. |
TYPE | SMALLINT | Indicates the type of information returned:
|
ORDINAL_POSITION | SMALLINT
Nullable |
Indicates the ordinal position of the key
in the index.
Contains the null value if the TYPE is 0. |
COLUMN_NAME | VARCHAR(128)
Nullable |
Name of the column for a key in the index.
Contains the null value if the TYPE is 0. |
ASC_OR_DESC | CHAR(1)
Nullable |
Order of the column in the key:
Contains the null value if the TYPE is 0. |
CARDINALITY | INTEGER
Nullable |
Reserved. Contains the null value. |
PAGES | INTEGER
Nullable |
Reserved. Contains the null value. |
FILTER_CONDITION | VARCHAR(128)
Nullable |
Indicates whether the index is a select/omit
index.
Contains the null value if the TYPE is 0 or this is not a select/omit index. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.