Neoview Query Guide (R2.2)

(
VERSION_ID NUMERIC(4) NO DEFAULT NOT NULL
, VERSION_TIME TIMESTAMP(0) NO DEFAULT NOT NULL
, VERSION_DESC VARCHAR(32) NO DEFAULT NOT NULL
MODULE_NAME CHAR(60) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT
, STATEMENT_NAME CHAR(6) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT NOT NULL
, PLAN_ID LARGEINT NO DEFAULT
, SEQ_NUM INT NO DEFAULT
, OPERATOR CHAR(30) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT
, LEFT_CHILD_SEQ_NUM INT NO DEFAULT
, RIGHT_CHILD_SEQ_NUM INT NO DEFAULT
, TNAME CHAR(60) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT
, CARDINALITY FLOAT(22) NO DEFAULT
, OPERATOR_COST FLOAT(22) NO DEFAULT
, TOTAL_COST FLOAT(22) NO DEFAULT
, DETAIL_COST CHAR(200) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT
, DESCRIPTION CHAR(3000) CHARACTER SET
ISO88591 COLLATE DEFAULT NO
DEFAULT
)
STORE BY (STATEMENT_NAME, SYSKEY )
NUMBER OF PARTITIONS 1
;
Capturing Query Plans for Review 15