Index
Index meta data.
- Value Params
- ascOrDesc
column sort sequence, "A" => ascending, "D" => descending, may be null if sort sequence is not supported; null when TYPE is tableIndexStatistic
- cardinality
When TYPE is tableIndexStatistic, then this is the number of rows in the table; otherwise, it is the number of unique values in the index.
- columnNames
target column names (collection of COLUMN_NAME without null values: column name; null when TYPE is tableIndexStatistic)
- filterCondition
Filter condition, if any. (may be null)
- indexType
index type: tableIndexStatistic, tableIndexClustered, tableIndexHashed, tableIndexOther
- isUnique
unique index (opposite of NON_UNIQUE: Can index values be non-unique. false when TYPE is tableIndexStatistic)
- name
name index name; null when TYPE is tableIndexStatistic
- ordinalPosition
column sequence number within index; zero when TYPE is tableIndexStatistic
- pages
When TYPE is tableIndexStatisic then this is the number of pages used for the table, otherwise it is the number of pages used for the current index.
- qualifier
index catalog (may be null); null when TYPE is tableIndexStatistic