------------------------------------------------ -- DDL Statements for table "YLA"."DSN_DETCOST_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_DETCOST_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "PLANNO" SMALLINT NOT NULL , "OPENIO" FLOAT(4) NOT NULL , "OPENCPU" FLOAT(4) NOT NULL , "OPENCOST" FLOAT(4) NOT NULL , "DMIO" FLOAT(4) NOT NULL , "DMCPU" FLOAT(4) NOT NULL , "DMTOT" FLOAT(4) NOT NULL , "SUBQIO" FLOAT(4) NOT NULL , "SUBQCPU" FLOAT(4) NOT NULL , "SUBQCOST" FLOAT(4) NOT NULL , "BASEIO" FLOAT(4) NOT NULL , "BASECPU" FLOAT(4) NOT NULL , "BASETOT" FLOAT(4) NOT NULL , "ONECOMPROWS" FLOAT(4) NOT NULL , "IMLEAF" FLOAT(4) NOT NULL , "IMIO" FLOAT(4) NOT NULL , "IMPREFH" CHAR(2) NOT NULL , "IMMPRED" INTEGER NOT NULL , "IMFF" FLOAT(4) NOT NULL , "IMSRPRED" INTEGER NOT NULL , "IMFFADJ" FLOAT(4) NOT NULL , "IMSCANCST" FLOAT(4) NOT NULL , "IMROWCST" FLOAT(4) NOT NULL , "IMPAGECST" FLOAT(4) NOT NULL , "IMRIDSORT" FLOAT(4) NOT NULL , "IMMERGCST" FLOAT(4) NOT NULL , "IMCPU" FLOAT(4) NOT NULL , "IMTOT" FLOAT(4) NOT NULL , "IMSEQNO" SMALLINT NOT NULL , "DMPREFH" CHAR(2) NOT NULL , "DMCLUDIO" FLOAT(4) NOT NULL , "DMNCLUDIO" FLOAT(4) NOT NULL , "DMPREDS" INTEGER NOT NULL , "DMSROWS" FLOAT(4) NOT NULL , "DMSCANCST" FLOAT(4) NOT NULL , "DMCOLS" SMALLINT NOT NULL , "DMROWS" FLOAT(4) NOT NULL , "RDSROWCST" FLOAT(4) NOT NULL , "DMPAGECST" FLOAT(4) NOT NULL , "DMDATAIO" FLOAT(4) NOT NULL , "DMDATACPU" FLOAT(4) NOT NULL , "DMDATATOT" FLOAT(4) NOT NULL , "RDSROW" FLOAT(4) NOT NULL , "SNCOLS" SMALLINT NOT NULL , "SNROWS" FLOAT(4) NOT NULL , "SNRECSZ" INTEGER NOT NULL , "SNPAGES" FLOAT(4) NOT NULL , "SNRUNS" FLOAT(4) NOT NULL , "SNMERGES" FLOAT(4) NOT NULL , "SNIOCOST" FLOAT(4) NOT NULL , "SNCPUCOST" FLOAT(4) NOT NULL , "SNCOST" FLOAT(4) NOT NULL , "SNSCANIO" FLOAT(4) NOT NULL , "SNSCANCPU" FLOAT(4) NOT NULL , "SNSCANCOST" FLOAT(4) NOT NULL , "SCCOLS" SMALLINT NOT NULL , "SCROWS" FLOAT(4) NOT NULL , "SCRECSZ" INTEGER NOT NULL , "SCPAGES" FLOAT(4) NOT NULL , "SCRUNS" FLOAT(4) NOT NULL , "SCMERGES" FLOAT(4) NOT NULL , "SCIOCOST" FLOAT(4) NOT NULL , "SCCPUCOST" FLOAT(4) NOT NULL , "SCCOST" FLOAT(4) NOT NULL , "SCSCANIO" FLOAT(4) NOT NULL , "SCSCANCPU" FLOAT(4) NOT NULL , "SCSCANCOST" FLOAT(4) NOT NULL , "COMPCARD" FLOAT(4) NOT NULL , "COMPIOCOST" FLOAT(4) NOT NULL , "COMPCPUCOST" FLOAT(4) NOT NULL , "COMPCOST" FLOAT(4) NOT NULL , "JOINCOLS" SMALLINT NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL , "COSTBLK" INTEGER NOT NULL , "COSTSTOR" INTEGER NOT NULL , "MPBLK" INTEGER NOT NULL , "MPSTOR" INTEGER NOT NULL , "COMPOSITES" INTEGER NOT NULL , "CLIPPED" INTEGER NOT NULL , "PARTITION" INTEGER NOT NULL , "TABREF" VARCHAR(64) FOR BIT DATA NOT NULL ); CREATE INDEX "YLA"."DETCOST_EXPIDX1" ON "YLA"."DSN_DETCOST_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_FILTER_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_FILTER_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "PLANNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT, "ORDERNO" INTEGER NOT NULL , "PREDNO" INTEGER NOT NULL , "STAGE" CHAR(9) NOT NULL , "ORDERCLASS" INTEGER NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "YLA"."FILTER_EXPIDX1" ON "YLA"."DSN_FILTER_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_FUNCTION_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_FUNCTION_TABLE" ( "QUERYNO" INTEGER NOT NULL WITH DEFAULT, "QBLOCKNO" INTEGER NOT NULL WITH DEFAULT, "APPLNAME" CHAR(8) NOT NULL WITH DEFAULT, "PROGNAME" VARCHAR(128) NOT NULL WITH DEFAULT, "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT, "GROUP_MEMBER" CHAR(8) NOT NULL WITH DEFAULT, "EXPLAIN_TIME" TIMESTAMP NOT NULL WITH DEFAULT, "SCHEMA_NAME" VARCHAR(128) NOT NULL WITH DEFAULT, "FUNCTION_NAME" VARCHAR(128) NOT NULL WITH DEFAULT, "SPEC_FUNC_NAME" VARCHAR(128) NOT NULL WITH DEFAULT, "FUNCTION_TYPE" CHAR(2) NOT NULL WITH DEFAULT, "VIEW_CREATOR" VARCHAR(128) NOT NULL WITH DEFAULT, "VIEW_NAME" VARCHAR(128) NOT NULL WITH DEFAULT, "PATH" VARCHAR(2048) NOT NULL WITH DEFAULT, "FUNCTION_TEXT" VARCHAR(1500) NOT NULL WITH DEFAULT ); CREATE INDEX "YLA"."FUNC_EXPIDX1" ON "YLA"."DSN_FUNCTION_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_PGRANGE_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_PGRANGE_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "TABNO" SMALLINT NOT NULL , "RANGE" SMALLINT NOT NULL , "FIRSTPART" SMALLINT NOT NULL , "LASTPART" SMALLINT NOT NULL , "NUMPARTS" SMALLINT NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "YLA"."PGR_EXPIDX1" ON "YLA"."DSN_PGRANGE_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_PGROUP_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_PGROUP_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "PLANNAME" CHAR(8) NOT NULL , "COLLID" VARCHAR(128) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL , "VERSION" VARCHAR(64) NOT NULL , "GROUPID" SMALLINT NOT NULL , "FIRSTPLAN" SMALLINT NOT NULL , "LASTPLAN" SMALLINT NOT NULL , "CPUCOST" FLOAT(4) NOT NULL , "IOCOST" FLOAT(4) NOT NULL , "BESTTIME" FLOAT(4) NOT NULL , "DEGREE" SMALLINT NOT NULL , "MODE" CHAR(1) NOT NULL , "REASON" SMALLINT NOT NULL , "LOCALCPU" SMALLINT NOT NULL , "TOTALCPU" SMALLINT NOT NULL , "FIRSTBASE" SMALLINT, "LARGETS" CHAR(1) , "PARTKIND" CHAR(1) , "GROUPTYPE" CHAR(3) , "ORDER" CHAR(1) , "STYLE" CHAR(4) , "RANGEKIND" CHAR(1) , "NKEYCOLS" SMALLINT, "LOWBOUND" VARCHAR(40) FOR BIT DATA , "HIGHBOUND" VARCHAR(40) FOR BIT DATA , "LOWKEY" VARCHAR(40) FOR BIT DATA , "HIGHKEY" VARCHAR(40) FOR BIT DATA , "FIRSTPAGE" CHAR(4) FOR BIT DATA , "LASTPAGE" CHAR(4) FOR BIT DATA ); CREATE INDEX "YLA"."GRP_EXPIDX1" ON "YLA"."DSN_PGROUP_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_PREDICAT_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_PREDICAT_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "PREDNO" INTEGER NOT NULL , "TYPE" CHAR(8) NOT NULL , "LEFT_HAND_SIDE" VARCHAR(128) NOT NULL , "LEFT_HAND_PNO" INTEGER NOT NULL , "LHS_TABNO" SMALLINT NOT NULL , "LHS_QBNO" SMALLINT NOT NULL , "RIGHT_HAND_SIDE" VARCHAR(128) NOT NULL , "RIGHT_HAND_PNO" INTEGER NOT NULL , "RHS_TABNO" SMALLINT NOT NULL , "RHS_QBNO" SMALLINT NOT NULL , "FILTER_FACTOR" FLOAT(8) NOT NULL , "BOOLEAN_TERM" CHAR(1) NOT NULL , "SEARCHARG" CHAR(1) NOT NULL , "JOIN" CHAR(1) NOT NULL , "AFTER_JOIN" CHAR(1) NOT NULL , "ADDED_PRED" CHAR(1) NOT NULL , "REDUNDANT_PRED" CHAR(1) NOT NULL , "DIRECT_ACCESS" CHAR(1) NOT NULL , "KEYFIELD" CHAR(1) NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL , "CATEGORY" SMALLINT NOT NULL , "CATEGORY_B" SMALLINT NOT NULL , "TEXT" VARCHAR(2000) NOT NULL , "PRED_ENCODE" CHAR(1) NOT NULL WITH DEFAULT, "PRED_CCSID" SMALLINT NOT NULL WITH DEFAULT, "PRED_MCCSID" SMALLINT NOT NULL WITH DEFAULT, "MARKER" CHAR(1) NOT NULL WITH DEFAULT, "PARENT_PNO" INTEGER NOT NULL , "NEGATION" CHAR(1) NOT NULL , "LITERALS" VARCHAR(128) NOT NULL , "CLAUSE" CHAR(8) NOT NULL ); CREATE INDEX "YLA"."PRED_EXPIDX1" ON "YLA"."DSN_PREDICAT_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_PTASK_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_PTASK_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "PGDNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "LPTNO" SMALLINT NOT NULL , "KEYCOLID" SMALLINT, "DPSI" CHAR(1) NOT NULL , "LPTLOKEY" VARCHAR(40) FOR BIT DATA , "LPTHIKEY" VARCHAR(40) FOR BIT DATA , "LPTLOPAG" CHAR(4) FOR BIT DATA , "LPTHIPAG" CHAR(4) FOR BIT DATA , "LPTLOPG#" CHAR(4) FOR BIT DATA , "LPTHIPG#" CHAR(4) FOR BIT DATA , "LPTLOPT#" SMALLINT, "LPTHIPT#" SMALLINT, "KEYCOLDT" SMALLINT, "KEYCOLPREC" SMALLINT, "KEYCOLSCAL" SMALLINT, "EXPLAIN_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "YLA"."PTASK_EXPIDX1" ON "YLA"."DSN_PTASK_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_QUERY_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_QUERY_TABLE" ( "QUERYNO" INTEGER NOT NULL , "TYPE" CHAR(8) NOT NULL , "QUERY_STAGE" CHAR(8) NOT NULL , "SEQNO" INTEGER NOT NULL , "NODE_DATA" CLOB(2097152) NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL , "QUERY_ROWID" ROWID NOT NULL , "HASHKEY" INTEGER NOT NULL , "HAS_PRED" CHAR(1) NOT NULL ); CREATE INDEX "YLA"."DSN_QUERY_IDX1" ON "YLA"."DSN_QUERY_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); CREATE INDEX "YLA"."DSN_QUERY_IDX2" ON "YLA"."DSN_QUERY_TABLE" ( "QUERYNO" ASC, "TYPE" ASC, "QUERY_STAGE" ASC, "EXPLAIN_TIME" ASC, "SEQNO" ASC); CREATE INDEX "YLA"."DSN_QUERY_UNIQIX" ON "YLA"."DSN_QUERY_TABLE" ( "QUERY_ROWID" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_SORTKEY_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_SORTKEY_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "PLANNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT, "SORTNO" SMALLINT NOT NULL , "ORDERNO" SMALLINT NOT NULL , "EXPTYPE" CHAR(3) NOT NULL , "TEXT" VARCHAR(128) NOT NULL , "TABNO" SMALLINT NOT NULL , "COLNO" SMALLINT NOT NULL , "DATATYPE" CHAR(18) NOT NULL , "LENGTH" INTEGER NOT NULL , "CCSID" INTEGER NOT NULL , "ORDERCLASS" INTEGER NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "YLA"."SORTK_EXPIDX1" ON "YLA"."DSN_SORTKEY_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_SORT_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_SORT_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "PLANNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT, "SORTC" CHAR(5) NOT NULL WITH DEFAULT, "SORTN" CHAR(5) NOT NULL WITH DEFAULT, "SORTNO" SMALLINT NOT NULL , "KEYSIZE" SMALLINT NOT NULL , "ORDERCLASS" INTEGER NOT NULL , "EXPLAIN_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "YLA"."SORT_EXPIDX1" ON "YLA"."DSN_SORT_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_STATEMENT_CACHE_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_STATEMENT_CACHE_TABLE" ( "STMT_ID" INTEGER NOT NULL , "STMT_TOKEN" VARCHAR(240) , "COLLID" VARCHAR(128) NOT NULL , "PROGRAM_NAME" VARCHAR(128) NOT NULL , "INV_DROPALT" CHAR(1) NOT NULL , "INV_REVOKE" CHAR(1) NOT NULL , "INV_LRU" CHAR(1) NOT NULL , "INV_RUNSTATS" CHAR(1) NOT NULL , "CACHED_TS" TIMESTAMP NOT NULL , "USERS" INTEGER NOT NULL , "COPIES" INTEGER NOT NULL , "LINES" INTEGER NOT NULL , "PRIMAUTH" VARCHAR(128) NOT NULL , "CURSQLID" VARCHAR(128) NOT NULL , "BIND_QUALIFIER" VARCHAR(128) NOT NULL , "BIND_ISO" CHAR(2) NOT NULL , "BIND_CDATA" CHAR(1) NOT NULL , "BIND_DYNRL" CHAR(1) NOT NULL , "BIND_DEGRE" CHAR(1) NOT NULL , "BIND_SQLRL" CHAR(1) NOT NULL , "BIND_CHOLD" CHAR(1) NOT NULL , "STAT_TS" TIMESTAMP NOT NULL , "STAT_EXEC" INTEGER NOT NULL , "STAT_GPAG" INTEGER NOT NULL , "STAT_SYNR" INTEGER NOT NULL , "STAT_WRIT" INTEGER NOT NULL , "STAT_EROW" INTEGER NOT NULL , "STAT_PROW" INTEGER NOT NULL , "STAT_SORT" INTEGER NOT NULL , "STAT_INDX" INTEGER NOT NULL , "STAT_RSCN" INTEGER NOT NULL , "STAT_PGRP" INTEGER NOT NULL , "STAT_ELAP" FLOAT(8) NOT NULL , "STAT_CPU" FLOAT(8) NOT NULL , "STAT_SUS_SYNIO" FLOAT(8) NOT NULL , "STAT_SUS_LOCK" FLOAT(8) NOT NULL , "STAT_SUS_SWIT" FLOAT(8) NOT NULL , "STAT_SUS_GLCK" FLOAT(8) NOT NULL , "STAT_SUS_OTHR" FLOAT(8) NOT NULL , "STAT_SUS_OTHW" FLOAT(8) NOT NULL , "STAT_RIDLIMT" INTEGER NOT NULL , "STAT_RIDSTOR" INTEGER NOT NULL , "EXPLAIN_TS" TIMESTAMP NOT NULL , "SCHEMA" VARCHAR(128) NOT NULL , "STMT_TEXT" CLOB(2097152) NOT NULL , "STMT_ROWID" ROWID NOT NULL ); CREATE INDEX "YLA"."DSN_STATEMENT_CACHE_IDX1" ON "YLA"."DSN_STATEMENT_CACHE_TABLE" ( "STMT_ID" ASC); CREATE INDEX "YLA"."DSN_STATEMENT_CACHE_IDX2" ON "YLA"."DSN_STATEMENT_CACHE_TABLE" ( "STMT_TOKEN" ASC) CLUSTER; CREATE INDEX "YLA"."DSN_STATEMENT_CACHE_IDX3" ON "YLA"."DSN_STATEMENT_CACHE_TABLE" ( "EXPLAIN_TS" DESC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_STATEMNT_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_STATEMNT_TABLE" ( "QUERYNO" INTEGER NOT NULL WITH DEFAULT, "APPLNAME" CHAR(8) NOT NULL WITH DEFAULT, "PROGNAME" VARCHAR(128) NOT NULL WITH DEFAULT, "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT, "GROUP_MEMBER" CHAR(8) NOT NULL WITH DEFAULT, "EXPLAIN_TIME" TIMESTAMP NOT NULL WITH DEFAULT, "STMT_TYPE" CHAR(6) NOT NULL WITH DEFAULT, "COST_CATEGORY" CHAR(1) NOT NULL WITH DEFAULT, "PROCMS" INTEGER NOT NULL WITH DEFAULT, "PROCSU" INTEGER NOT NULL WITH DEFAULT, "REASON" VARCHAR(254) NOT NULL WITH DEFAULT, "STMT_ENCODE" CHAR(1) NOT NULL ); CREATE INDEX "YLA"."STMT_EXPIDX1" ON "YLA"."DSN_STATEMNT_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_STRUCT_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_STRUCT_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "PARENT" SMALLINT NOT NULL , "TIMES" FLOAT(8) NOT NULL , "ROWCOUNT" INTEGER NOT NULL , "ATOPEN" CHAR(1) NOT NULL , "CONTEXT" CHAR(10) NOT NULL , "ORDERNO" SMALLINT NOT NULL , "DOATOPEN_PARENT" SMALLINT NOT NULL , "QBLOCK_TYPE" CHAR(6) NOT NULL WITH DEFAULT, "EXPLAIN_TIME" TIMESTAMP NOT NULL , "QUERY_STAGE" CHAR(8) NOT NULL ); CREATE INDEX "YLA"."STRUC_EXPIDX1" ON "YLA"."DSN_STRUCT_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."DSN_VIEWREF_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."DSN_VIEWREF_TABLE" ( "QUERYNO" INTEGER NOT NULL WITH DEFAULT, "APPLNAME" CHAR(8) NOT NULL WITH DEFAULT, "PROGNAME" VARCHAR(128) NOT NULL WITH DEFAULT, "VERSION" VARCHAR(64) NOT NULL WITH DEFAULT, "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT, "CREATOR" VARCHAR(128) NOT NULL WITH DEFAULT, "NAME" VARCHAR(128) NOT NULL WITH DEFAULT, "TYPE" CHAR(1) NOT NULL WITH DEFAULT, "MQTUSE" SMALLINT NOT NULL WITH DEFAULT, "EXPLAIN_TIME" TIMESTAMP NOT NULL WITH DEFAULT ); CREATE INDEX "YLA"."VIEW_EXPIDX1" ON "YLA"."DSN_VIEWREF_TABLE" ( "QUERYNO" ASC, "EXPLAIN_TIME" ASC); ------------------------------------------------ -- DDL Statements for table "YLA"."PLAN_TABLE" ------------------------------------------------ CREATE TABLE "YLA"."PLAN_TABLE" ( "QUERYNO" INTEGER NOT NULL , "QBLOCKNO" SMALLINT NOT NULL , "APPLNAME" CHAR(8) NOT NULL , "PROGNAME" VARCHAR(128) NOT NULL , "PLANNO" SMALLINT NOT NULL , "METHOD" SMALLINT NOT NULL , "CREATOR" VARCHAR(128) NOT NULL , "TNAME" VARCHAR(128) NOT NULL , "TABNO" SMALLINT NOT NULL , "ACCESSTYPE" CHAR(2) NOT NULL , "MATCHCOLS" SMALLINT NOT NULL , "ACCESSCREATOR" VARCHAR(128) NOT NULL , "ACCESSNAME" VARCHAR(128) NOT NULL , "INDEXONLY" CHAR(1) NOT NULL , "SORTN_UNIQ" CHAR(1) NOT NULL , "SORTN_JOIN" CHAR(1) NOT NULL , "SORTN_ORDERBY" CHAR(1) NOT NULL , "SORTN_GROUPBY" CHAR(1) NOT NULL , "SORTC_UNIQ" CHAR(1) NOT NULL , "SORTC_JOIN" CHAR(1) NOT NULL , "SORTC_ORDERBY" CHAR(1) NOT NULL , "SORTC_GROUPBY" CHAR(1) NOT NULL , "TSLOCKMODE" CHAR(3) NOT NULL , "TIMESTAMP" CHAR(16) NOT NULL , "REMARKS" VARCHAR(762) NOT NULL , "PREFETCH" CHAR(1) NOT NULL , "COLUMN_FN_EVAL" CHAR(1) NOT NULL , "MIXOPSEQ" SMALLINT NOT NULL , "VERSION" VARCHAR(64) NOT NULL , "COLLID" VARCHAR(128) NOT NULL , "ACCESS_DEGREE" SMALLINT, "ACCESS_PGROUP_ID" SMALLINT, "JOIN_DEGREE" SMALLINT, "JOIN_PGROUP_ID" SMALLINT, "SORTC_PGROUP_ID" SMALLINT, "SORTN_PGROUP_ID" SMALLINT, "PARALLELISM_MODE" CHAR(1) , "MERGE_JOIN_COLS" SMALLINT, "CORRELATION_NAME" VARCHAR(128) , "PAGE_RANGE" CHAR(1) NOT NULL WITH DEFAULT, "JOIN_TYPE" CHAR(1) NOT NULL WITH DEFAULT, "GROUP_MEMBER" CHAR(8) NOT NULL WITH DEFAULT, "IBM_SERVICE_DATA" VARCHAR(254) FOR BIT DATA NOT NULL WITH DEFAULT, "WHEN_OPTIMIZE" CHAR(1) NOT NULL WITH DEFAULT, "QBLOCK_TYPE" CHAR(6) NOT NULL WITH DEFAULT, "BIND_TIME" TIMESTAMP NOT NULL WITH DEFAULT, "OPTHINT" VARCHAR(128) NOT NULL WITH DEFAULT, "HINT_USED" VARCHAR(128) NOT NULL WITH DEFAULT, "PRIMARY_ACCESSTYPE" CHAR(1) NOT NULL WITH DEFAULT, "PARENT_QBLOCKNO" SMALLINT NOT NULL , "TABLE_TYPE" CHAR(1) , "TABLE_ENCODE" CHAR(1) NOT NULL WITH DEFAULT, "TABLE_SCCSID" SMALLINT NOT NULL WITH DEFAULT, "TABLE_MCCSID" SMALLINT NOT NULL WITH DEFAULT, "TABLE_DCCSID" SMALLINT NOT NULL WITH DEFAULT, "ROUTINE_ID" INTEGER NOT NULL WITH DEFAULT, "CTEREF" SMALLINT NOT NULL WITH DEFAULT, "STMTTOKEN" VARCHAR(240) ); CREATE INDEX "YLA"."PLAN_EXPIDX1" ON "YLA"."PLAN_TABLE" ( "QUERYNO" ASC, "BIND_TIME" ASC);