1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT CAST(PROGNAME AS CHAR(8)), QUERYNO, QBLOCKNO, PLANNO,
SUBSTR(DIGITS(MIXOPSEQ),3,3), ' ', SUBSTR(DIGITS(METHOD),3,3),
CAST(TNAME AS CHAR(18)), ACCESSTYPE, SUBSTR(DIGITS(MATCHCOLS),3,3),
CAST(ACCESSNAME AS CHAR(18)), INDEXONLY, SORTN_UNIQ, SORTN_JOIN,
SORTN_ORDERBY, SORTN_GROUPBY, SORTC_UNIQ, SORTC_JOIN, SORTC_ORDERBY,
SORTC_GROUPBY, TSLOCKMODE, PREFETCH, SUBSTR(DIGITS(TABNO),3,3),
COLUMN_FN_EVAL, SUBSTR(DIGITS(ACCESS_DEGREE),3,3),
SUBSTR(DIGITS(ACCESS_PGROUP_ID),3,3), SUBSTR(DIGITS(JOIN_DEGREE),3,3),
SUBSTR(DIGITS(JOIN_PGROUP_ID),3,3), SUBSTR(DIGITS(SORTC_PGROUP_ID),3,3),
SUBSTR(DIGITS(SORTN_PGROUP_ID),3,3), PARALLELISM_MODE,
SUBSTR(DIGITS(MERGE_JOIN_COLS),3,3), PAGE_RANGE, JOIN_TYPE,
WHEN_OPTIMIZE, QBLOCK_TYPE, TIMESTAMP, PARENT_QBLOCKNO,
CHAR(COALESCE(TABLE_TYPE, ' '), 1) |
Partager