Table name | Type | Key length3 (Variable g1) | Number of key types (Variable c1) | Average number of key duplicates (Variable d1) |
---|
SQL_PHYSICAL_FILES | 1 | 8 | Number of servers | Average number of HiRDB files in server |
2 | g + 1 | Number of RDAREAs | Average number of HiRDB files constituting an RDAREA |
SQL_RDAREAS | 3 | g + 1 | Number of RDAREAs | 1 |
4 | 4 |
SQL_TABLES | 5 | d + e + 2 | Total number of tables + 80 | 1 |
6 | 4 |
SQL_COLUMNS | 7 | d + e + f + 3 | a b | 1 |
8 | d + e + 6 |
9 | 4 | b |
SQL_INDEXES | 10 | d + e + 2 | a | h a![[Figure]](figure/zueng010.gif) |
11 | d + i + 2 | h | 1 |
12 | 4 |
SQL_USERS | 13 | d + 1 | Number of authorization identifiers | 1 |
SQL_RDAREA_ PRIVILEGES | 14 | d + 1 | Number of unique authorization identifiers specified in the USER USED BY operand of the database initialization utility (pdinit) | Average number of RDAREA access privileges used per user |
15 | g + 1 | Number of RDAREAs specified in the USER USED BY operand of the database initialization utility (pdinit) | Average number of users for each RDAREA |
SQL_TABLE_PRIVILEGES | 16 | d + 1 | a | y a![[Figure]](figure/zueng010.gif) |
17 | 2 d + e + 3 | y | 1 |
SQL_DIV_TABLE | 18 | d + e + 6 | Total number of table partitions | 1 |
19 | g + 1 | Number of unique RDAREAs specified when partitioning table | Average number of tables stored in RDAREAs |
20 | 4 |
SQL_DIV_TABLE_REGULARSIZE | 21 | d + e + 6 | Total number of table partitions | 1 |
22 | 4 | Number of row-partitioned tables | Average number of table partitions |
SQL_INDEX_COLINF | 23 | d + e + 6 | Number of unique tables with index definitions | Average number of columns constituting an index |
24 | d + i + 6 | Number of columns constituting an index | 1 |
SQL_TABLE_STATISTICS | 25 | d + e + 2 | Total number of tables (including dictionary tables) | 1 |
SQL_COLUMN_STATISTICS | 26 | d + e + f + 3 | h | 1 |
SQL_INDEX_STATISTICS | 27 | d + e + 2 | Total number of tables for which an index is defined | h a![[Figure]](figure/zueng010.gif) |
28 | d + i + 2 | h | 1 |
SQL_VIEW_TABLE_USAGE | 29 | d + e + 2 | z | 1 |
30 | d + e + 2 | Total number of base tables for which a view is defined | Average number of view definitions for a table |
31 | 4 | z | 1 |
SQL_VIEWS | 32 | d + e + 2 | z | 1 |
33 | 4 |
SQL_VIEW_DEF | 34 | d + e + 2 | z | 1 |
35 | 10 |
SQL_REFERENTIAL_CONSTRAINTS | 39 | d + e + 2 | Total number of referential constraints | 1 |
40 | d + e + 2 | Total number of referencing tables | Average number of referencing tables per table |
41 | d + e + 2 | Total number of referenced table | Average number of referenced tables per table |
SQL_EXCEPT | 86 | d + e + 2 | Number of indexes for which an exception value is specified | Number of indexes with an exception value specified for a single table |
87 | d + i + 2 | 1 |
88 | 4 | Number of unique tables with an index for which an exception value is specified | Number of indexes for which an exception value is specified for a single table |
SQL_DIV_INDEX | 36 | d + e + 6 | Number of row-partitioned indexes number of partitions | Average number of partitions per table |
37 | d + i + 2 | Total number of row-partitioned indexes | 1 |
SQL_DIV_COLUMN | 38 | d + e + f + 3 | Number of LOB column definitions | Average number of partitions per table |
52 | d + e + 9 | Number of LOB attribute definitions | 1 |
SQL_ALIASES | 42 | d + v + 4 | Total number of table aliases to be created | 1 |
SQL_ROUTINES | 43 | d + MAX (q, 7) | p + 174 | 1 |
44 | d + MAX (t, 18) | u + 65 | 1 |
45 | 4 | p + 174 | 1 |
53 | d + UDT | Number of abstract data types + 1 (NULL value) | Average number of routines per abstract data type + number of NULL |
SQL_ROUTINE_RESOURCES | 46 | d + q | p s | Average number of resources used per routine |
47 | d + t |
48 | d + q |
49 | 4 |
SQL_ROUTINE_PARAMS | 50 | d + MAX (q, 8) | p r + 347 | Average number of parameters per routine |
51 | d + MAX (t, 19) | Number of routines | Average number of parameters per specific name (if less than 3, use 3) |
106 | e + 4 + 2 | Number of trigger SQL objects r + 1 (NULL values) | Average number of parameters per specified name (if less that 3, use 3) + number of NULL values |
SQL_DATATYPES | 54 | d + UDT | Number of abstract data types | 1 |
55 | 4 |
56 | d + UDT | Number of abstract data types that have subtypes + 1 (NULL value) | Average number of subtypes per abstract data type + number of NULL values |
SQL_DATATYPE_DESCRIPTORS | 57 | d + UDT + ATT | NUDT NATT | 1 |
58 | 4 | Number of abstract data types | Average number of attributes per abstract data type |
SQL_TABLE_RESOURCES | 59 | d + e | Total number of tables that use user-defined data types | Average number of user-defined data types used per table |
60 | d + UDT | UDT | Average number of tables used per user-defined data type |
61 | 4 |
SQL_PLUGINS | 62 | d + PLG | Number of plug-ins | 1 |
63 | 4 |
64 | {(d + UDT) IXT} + 2 | Number of data type plug-ins + number of index-type plug-ins |
SQL_PLUGIN_ROUTINES | 65 | t | NPLG NFPLG | 1 |
66 | PLG + TMD + 2 | Number of operations | Number of plug-ins |
67 | PLG + 4 |
68 | POPR + 1 |
SQL_PLUGIN_ROUTINE_PARAMS | 69 | t + PRM | NPLG NPPAR | 1 |
70 | PLG | NPLG | Average number of parameters per plug-in |
71 | t + 4 | NPLG NPPAR | 1 |
SQL_REGISTRY_CONTEXT | 72 | CNM + 1 | Number of contexts | 1 |
SQL_REGISTRY_KEY | 73 | KNM + 6 | Number of keys | 1 |
SQL_INDEX_TYPES | 74 | d + IXT | Number of index types to be created | 1 |
75 | 4 |
SQL_INDEX_RESOURCES | 76 | d + IXT | Number of plug-in indexes | Average number of index definitions that use index type |
77 | 4 |
SQL_INDEX_DATATYPE | 78 | d + e | Number of table definitions for which plug-in index is defined | Average number of plug-in indexes for the same table |
79 | d + i | Number of plug-in indexes | 1 |
SQL_INDEX_FUNCTION | 80 | d + e | Number of table definitions for which plug-in index is defined | Average number of plug-in indexes per table average number of functions to which plug-in index is applied |
81 | d + i | Number of plug-in indexes | Average number of functions to be applied per plug-in index |
SQL_TYPE_RESOURCES | 82 | d + e | Number of user-defined data types that use a user-defined data type | Average number of user-defined data types that are specified as an attribute of a user-defined data type |
83 | d + UDT | Number of user-defined data types | Average number of user-defined data types that use a user-defined data type |
84 | 4 |
SQL_INDEX_TYPE_FUNCTION | 85 | d + IXT | Number of index types | Average number of functions to be applied per index |
SQL_UER_MAPPINGS | 89 | d + FSRV | Number of user mappings | 1 |
SQL_TRIGGERS | 90 | d + e + 2 + 16 | Number of triggers | 1 |
91 | d + TRIG + 2 |
92 | d + t + 2 |
93 | 4 |
SQL_TRIGGER_COLUMNS | 96 | d + TRIG + 2 | Number of triggers that use the UPDATE statement as the triggering event | Average column length specified per trigger |
97 | d + e + f + 3 | Number of columns specified that use the UPDATE statement as the triggering event | 1 |
SQL_TRIGGER_DEF_SOURCE | 98 | d + TRIG + 2 + 4 | Number of triggers | 1 |
99 | d + e + 2 | Number of tables defined with triggers | Average number of triggers per table |
SQL_TRIGGER_USAGE | 100 | d + TRIG + 2 | Number of triggers that reference resources while performing the trigger action search condition | Average number of resources referenced per trigger |
101 | d + e + 2 | Number of tables that define triggers that reference resources while performing the trigger action search conditions | Average number of resources referenced per table |
102 | d + e + (t or e) + 2 | Number of resources used | 1 |
103 | 8 |
SQL_PARTKEY | 104 | d + e + f + 3 | Number of matrix partitioning tables number of partitioning keys | 1 |
SQL_PARTKEY_DIVISION | 105 | d + e + 6 | Number of matrix partitioning tables number of boundary values number of partitioning keys | 1 |
SQL_AUDITS | 107 | ETP + EST + 2 | Number of monitored events | 1 |
108 | OTP + OSC + ONM + 3 | Number of monitored objects | Average number of events monitored per object |
109 | d | Number of monitored users | Average number of events monitored per user |
SQL_AUDITS_REGULARIZE | 110 | OTP + OSC + ONM + 3 | Number of monitored objects | Average number of events monitored per object |
111 | d | Number of monitored users | Average number of events monitored per user |
SQL_KEYCOLUMN_USAGE | 112 | d + CNS + 2 | Number of constraints | 1 |
113 | d + e + 2 | Number of tables for which constraints have been defined | Average number of constraints per table |
SQL_TABLE_CONSTRAINTS | 114 | d + CNS + 2 | Number of constraints | 1 |
115 | d + e + 2 | Number of tables for which constraints have been defined | Average number of constraints per table |
SQL_CHECKS | 116 | d + CNS + 2 | Number of check constraints | 1 |
117 | d + e + 2 | Number of tables for which check constraints have been defined | Average number of check constraints per table |
SQL_CHECK_COLUMNS | 118 | d + CNS + 2 | Number of check constraints | Average number of columns specified per check constraint |
119 | d + e + f + 3 | Number of columns used in the check constraints | Average number of duplicate columns used in check constraints per table |
SQL_SYSPARAMS | 121 | 8 | 2 | 1 |
SQL_PUBLICVIEW_SAME_USERS | 124 | d + e + 2 | Number of public view tables number of authorization identifiers | 1 |