B.21 B-tree indexes of dictionary tables (base tables)

The following table shows the B-tree indexes defined for dictionary tables (base tables).

Table B‒22: List of B-tree indexes of dictionary tables (base tables)
No.	Dictionary table (base table)	Indexed column	B-tree index name
1	`SQL_TABLES`	`TABLE_SCHEMA`	`SQLINDEXM01`
2		`TABLE_NAME`	`SQLINDEXM01`
3		`TABLE_ID`	`SQLINDEXS01`
4	`SQL_COLUMNS`	`TABLE_SCHEMA`	`SQLINDEXM02`
5		`TABLE_NAME`
6		`COLUMN_NAME`
7		`TABLE_ID`	`SQLINDEXS02`
8	`SQL_DIV_TABLE`	`TABLE_SCHEMA`	`SQLINDEXM05`
9		`TABLE_NAME`	`SQLINDEXM05`
10		`DBAREA_ID`	`SQLINDEXS04`
11	`SQL_INDEXES`	`TABLE_SCHEMA`	`SQLINDEXM03`
12		`INDEX_NAME`	`SQLINDEXM03`
13		`TABLE_SCHEMA`	`SQLINDEXM04`
14		`TABLE_NAME`	`SQLINDEXM04`
15		`INDEX_ID`	`SQLINDEXS03`
16	`SQL_DIV_INDEX`	`TABLE_SCHEMA`	`SQLINDEXM06`
17		`TABLE_NAME`	`SQLINDEXM06`
18		`TABLE_SCHEMA`	`SQLINDEXM07`
19		`INDEX_NAME`	`SQLINDEXM07`
20		`DBAREA_ID`	`SQLINDEXS05`
21	`SQL_DBAREAS`	`DBAREA_NAME`	`SQLINDEXS06`
22		`DBAREA_ID`	`SQLINDEXS07`
23		`N_TABLE`	`SQLINDEXM08`
24		`DBAREA_ID`	`SQLINDEXM08`
25	`SQL_SCHEMATA`	`SCHEMA_OWNER`	`SQLINDEXS08`
26	`SQL_SCHEMATA`	`SCHEMA_NAME`	`SQLINDEXS09`
27	`SQL_VIEWS`	`TABLE_SCHEMA`	`SQLINDEXM09`
28		`TABLE_NAME`	`SQLINDEXM09`
29		`VIEW_ID`	`SQLINDEXS10`
30	`SQL_VIEW_TABLE_USAGE`	`VIEW_SCHEMA`	`SQLINDEXM10`
31		`VIEW_NAME`	`SQLINDEXM10`
32		`TABLE_SCHEMA`	`SQLINDEXM11`
33		`TABLE_NAME`	`SQLINDEXM11`
34		`VIEW_ID`	`SQLINDEXS11`
35	`SQL_VIEW_OBJECT`	`VIEW_ID`	`SQLINDEXM12`
36	`SQL_VIEW_OBJECT`	`OBJECT_NO`	`SQLINDEXM12`
37	`SQL_DEFINE_SOURCE`	`SOURCE_ID`	`SQLINDEXS12`
38	`SQL_DEFINE_ENVIRONMENT`	`RESOURCE_TYPE`	`SQLINDEXM13`
39	`SQL_DEFINE_ENVIRONMENT`	`RESOURCE_ID`	`SQLINDEXM13`
40	`SQL_USERS`	`USER_NAME`	`SQLINDEXS13`
41	`SQL_TABLE_CONSTRAINTS`	`CONSTRAINT_SCHEMA`	`SQLINDEXM14`
42		`CONSTRAINT_NAME`	`SQLINDEXM14`
43		`TABLE_SCHEMA`	`SQLINDEXM15`
44		`TABLE_NAME`	`SQLINDEXM15`
45	`SQL_INDEX_COLINF`	`TABLE_SCHEMA`	`SQLINDEXM16`
46		`INDEX_NAME`	`SQLINDEXM16`
47		`TABLE_SCHEMA`	`SQLINDEXM17`
48		`TABLE_NAME`	`SQLINDEXM17`
49	`SQL_KEY_COLUMN_USAGE`	`CONSTRAINT_SCHEMA`	`SQLINDEXM18`
50		`CONSTRAINT_NAME`
51		`COLUMN_NAME`
52		`TABLE_SCHEMA`	`SQLINDEXM19`
53		`TABLE_NAME`
54		`COLUMN_NAME`
55	`SQL_REFERENTIAL_CONSTRAINTS`	`CONSTRAINT_SCHEMA`	`SQLINDEXM20`
56		`CONSTRAINT_NAME`	`SQLINDEXM20`
57		`TABLE_SCHEMA`	`SQLINDEXM21`
58		`TABLE_NAME`	`SQLINDEXM21`
59		`PRIMARY_CONSTRAINT_SCHEMA`	`SQLINDEXM22`
60		`PRIMARY_CONSTRAINT_NAME`	`SQLINDEXM22`
61		`REFERENCED_TABLE_SCHEMA`	`SQLINDEXM23`
62		`REFERENCED_TABLE_NAME`	`SQLINDEXM23`
63	`SQL_TABLE_PRIVILEGES`	`TABLE_SCHEMA`	`SQLINDEXM24`
64		`TABLE_NAME`
65		`GRANTEE`
66		`GRANTOR`
67		`GRANTOR`	`SQLINDEXS14`
68		`GRANTEE`	`SQLINDEXS15`
69	`SQL_AUDITS`	`OBJECT_TYPE`	`SQLINDEXM25`
70		`OBJECT_SCHEMA`
71		`OBJECT_NAME`

To Page Top