C.8 B-tree indexes of system tables (base tables)
The following table shows the B-tree indexes defined for system tables (base tables).
|
No. |
System table |
Indexed column |
B-tree index name |
|---|---|---|---|
|
1 |
STATUS_TABLES |
TABLE_SCHEMA |
STATUSINDEXM01 |
|
2 |
TABLE_NAME |
||
|
3 |
STATUS_COLUMNS |
TABLE_SCHEMA |
STATUSINDEXM02 |
|
4 |
TABLE_NAME |
||
|
5 |
COLUMN_NAME |
||
|
6 |
STATUS_INDEXES |
TABLE_SCHEMA |
STATUSINDEXM03 |
|
7 |
INDEX_NAME |
||
|
8 |
TABLE_SCHEMA |
STATUSINDEXM04 |
|
|
9 |
TABLE_NAME |
||
|
10 |
STATUS_CHUNKS |
TABLE_SCHEMA |
STATUSINDEXM05 |
|
11 |
TABLE_NAME |
||
|
12 |
CHUNK_ID |
||
|
13 |
STATUS_SYNONYM_DICTIONARIES |
SYNONYM_DICTIONARY_NAME |
STATUSINDEXS01 |