B.6 Content of SQL_DIV_INDEX
SQL_DIV_INDEX stores information about locations such as DB areas that store indexes of base tables. It also stores information about locations such as DB areas that store B-tree indexes for dictionary tables (base tables) and system tables (base tables). Each row stores information for one index.
The following table describes the content of SQL_DIV_INDEX.
|
No. |
Column name |
Data type |
Stored information |
|---|---|---|---|
|
1 |
TABLE_SCHEMA |
VARCHAR(100) |
Schema name |
|
2 |
TABLE_NAME |
VARCHAR(100) |
Table identifier of the table for which the index is defined |
|
3 |
INDEX_NAME |
VARCHAR(100) |
Index identifier |
|
4 |
INDEX_ID |
SMALLINT |
Index ID:
|
|
5 |
DBAREA_ID |
SMALLINT |
DB area ID of the DB area that stores the indexes |