C.4 Content of STATUS_INDEXES

STATUS_INDEXES stores cost information related to indexes. Each row stores information for one index.

The following table describes the contents of STATUS_INDEXES.

Table C‒5: Content of STATUS_INDEXES
No.	Column name	Data type	Stored information
1	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name
2	`TABLE_NAME`	`VARCHAR(100)`	Table identifier
3	`INDEX_NAME`	`VARCHAR(100)`	Index identifier
4	`INDEX_TYPE`	`CHAR(1)`	Index type: `'B'`: B-tree index `'T'`: Text index
5	`COLLECT_TIME`	`TIMESTAMP`	Date and time cost information was collected