CREATE INDEX DB2OSC.DSN_QUERY_TABLE_IDX1 01245200
ON DB2OSC.DSN_QUERY_TABLE 01245240
( "QUERYNO" 01245280
,"EXPLAIN_TIME" 01245320
); 01245360
CREATE INDEX DB2OSC.DSN_QUERY_TABLE_IDX2 01245400
ON DB2OSC.DSN_QUERY_TABLE 01245440
( "QUERYNO" 01245480
,"TYPE" 01245520
,"QUERY_STAGE" 01245560
,"EXPLAIN_TIME" 01245600
,"SEQNO" 01245640
); 01245680
CREATE UNIQUE INDEX DB2OSC.DSN_QUERY_TABLE_IDX3 01245720
ON DB2OSC.DSN_QUERY_TABLE 01245760
( "QUERY_ROWID" 01245800
); 01245840
CREATE AUX TABLE DB2OSC.DSN_QUERY_AUX 01245880
IN DB2OSC.DSNLOBT2 01245920
STORES DB2OSC.DSN_QUERY_TABLE 01245960
COLUMN "NODE_DATA"; 01246000
CREATE INDEX DB2OSC.DSN_QUERY_AUXINX 01246040
ON DB2OSC.DSN_QUERY_AUX; 01246080
CREATE UNIQUE INDEX SYSIBM.DSN_PROFILE_TABLE_IX_ALL 01810000
ON SYSIBM.DSN_PROFILE_TABLE 01820000
( "PROFILEID" 01830000
); 01840000
CREATE INDEX SYSIBM.DSN_PROFILE_TABLE_IX2_ALL 01850000
ON SYSIBM.DSN_PROFILE_TABLE 01860000
( "PROFILE_ENABLED" 01870000
,"AUTHID" 01880000
,"PLANNAME" 01890000
,"COLLID" 01900000
,"PKGNAME" 01910000
,"IPADDR" 01920000
,"PROFILE_TIMESTAMP" DESC 01930000
); 01940000
CREATE UNIQUE INDEX SYSIBM.DSN_PROFILE_ATTRIBUTES_IX_ALL 02220000
ON SYSIBM.DSN_PROFILE_ATTRIBUTES 02230000
( "PROFILEID" 02240000
,"ATTRIBUTE_TIMESTAMP" DESC 02250000
,"KEYWORDS" 02260000
,"ATTRIBUTE1" 02270000
,"ATTRIBUTE2" 02280000
,"ATTRIBUTE3" 02290000
) 02300000
USING STOGROUP DSNOSCSG; 02310000
CREATE UNIQUE INDEX SYSIBM.DSN_STATEMENT_RUNTIME_INFO_IDX1 03160000
ON SYSIBM.DSN_STATEMENT_RUNTIME_INFO 03170000
( "STMT_RUNTIME_INFO_ID" 03180000
) 03190000
USING STOGROUP DSNOSCSG; 03200000
CREATE INDEX SYSIBM.DSN_STATEMENT_RUNTIME_INFO_AUXINX 03280000
ON SYSIBM.DSN_STATEMENT_RUNTIME_INFO_AUX 03290000
USING STOGROUP DSNOSCSG; 03300000
CREATE INDEX SYSIBM.PLAN_TABLE_IDX1 04380000
ON SYSIBM.PLAN_TABLE 04390000
( "QUERYNO" 04400000
,"BIND_TIME" 04410000
); 04420000
CREATE INDEX SYSIBM.DSN_STATEMNT_TABLE_IDX1 04600000
ON SYSIBM.DSN_STATEMNT_TABLE 04610000
( "QUERYNO" 04620000
,"EXPLAIN_TIME" 04630000
); 04640000
CREATE INDEX SYSIBM.FUNC_EXPIDX1 04930000
ON SYSIBM.DSN_FUNCTION_TABLE 04940000
( "QUERYNO" 04950000
,"EXPLAIN_TIME" 04960000
); 04970000
CREATE INDEX SYSIBM.DSN_PREDICAT_TABLE_IDX1 05500000
ON SYSIBM.DSN_PREDICAT_TABLE 05510000
( "QUERYNO" 05520000
,"EXPLAIN_TIME" 05530000
); 05540000
CREATE INDEX SYSIBM.DSN_STRUCT_TABLE_IDX1 05740000
ON SYSIBM.DSN_STRUCT_TABLE 05750000
( "QUERYNO" 05760000
,"EXPLAIN_TIME" 05770000
); 05780000
CREATE INDEX SYSIBM.DSN_PTASK_TABLE_IDX1 06510000
ON SYSIBM.DSN_PTASK_TABLE 06520000
( "QUERYNO" 06530000
,"EXPLAIN_TIME" 06540000
); 06550000
CREATE INDEX SYSIBM.DSN_FILTER_TABLE_IDX1 06740000
ON SYSIBM.DSN_FILTER_TABLE 06750000
( "QUERYNO" 06760000
,"EXPLAIN_TIME" 06770000
); 06780000
CREATE INDEX SYSIBM.DSN_DETCOST_TABLE_IDX1 08040000
ON SYSIBM.DSN_DETCOST_TABLE 08050000
( "QUERYNO" 08060000
,"EXPLAIN_TIME" 08070000
); 08080000
CREATE INDEX SYSIBM.DSN_SORT_TABLE_IDX1 08260000
ON SYSIBM.DSN_SORT_TABLE 08270000
( "QUERYNO" 08280000
,"EXPLAIN_TIME" 08290000
); 08300000
CREATE INDEX SYSIBM.DSN_SORTKEY_TABLE_IDX1 08530000
ON SYSIBM.DSN_SORTKEY_TABLE 08540000
( "QUERYNO" 08550000
,"EXPLAIN_TIME" 08560000
); 08570000
CREATE INDEX SYSIBM.DSN_PGRANGE_TABLE_IDX1 08710000
ON SYSIBM.DSN_PGRANGE_TABLE 08720000
( "QUERYNO" 08730000
,"EXPLAIN_TIME" 08740000
); 08750000
CREATE INDEX SYSIBM.DSN_VIEWREF_TABLE_IDX1 08910000
ON SYSIBM.DSN_VIEWREF_TABLE 08920000
( "QUERYNO" 08930000
,"EXPLAIN_TIME" 08940000
); 08950000
CREATE INDEX SYSIBM.DSN_QUERY_TABLE_IDX1 09110000
ON SYSIBM.DSN_QUERY_TABLE 09120000
( "QUERYNO" 09130000
,"EXPLAIN_TIME" 09140000
); 09150000
CREATE INDEX SYSIBM.DSN_QUERY_TABLE_IDX2 09160000
ON SYSIBM.DSN_QUERY_TABLE 09170000
("QUERYNO" 09180000
,"TYPE" 09190000
,"QUERY_STAGE" 09200000
,"EXPLAIN_TIME" 09210000
,"SEQNO" 09220000
); 09230000
CREATE INDEX SYSIBM.DSN_QUERY_AUXINX 09280000
ON SYSIBM.DSN_QUERY_AUX; 09290000