SELECT Clause Format: Indexes
SELECT
1,
TABLE_OWNER,
TABLE_NAME,
NON_UNIQUE,
1,
INDEX_NAME,
TYPE,
SEQ_IN_INDEX,
COLUMN_NAME,
COLLATION
FROM ...
WHERE ...
• TABLE_OWNER: name of the owner of the table concerned by the statistic or the index
• TABLE_NAME: name of the index table
• NON_UNIQUE: the indexes must have a unique value
• INDEX_NAME: name of the index
• TYPE : Index type
• SEQ_IN_INDEX: number of the column in the key sequence (starts at 1)
• COLUMN_NAME: name of the column
• COLLATION: column sort; "A" increasing order, "D" decreasing order