This sample shows the report with one Enclave token expanded to the third level (SQL text).
File View Navigate Help -------------------------------------------------------------------------------- F16: DB2 SQL CPU/Svc Time by Enclave (1641/DB2ADIST) Row 00001 of 01410 Command ===> __________________________________________________ Scroll ===> PAGE Nbr of --CPU Time-- --Svc Time-- Token Stmt# SQL Function SQL Calls Total Mean Total Mean 00000020-0000017E 1 0.04 0.04177 0.05 0.05652 ± D00026 0 EXECUTE IMME 1 0.04 0.04177 0.05 0.05652 > EXPLAIN PLAN SET QUERYNO=1 FOR SELECT > COALESCE(FIELD_ONE_KEY, DEP2_COL1_KEY) AS COL1_KEY > ,COALESCE(DEP2_COL2_KEY, DEP3_COL2_KEY) AS COL2_KEY > ,DEP3_COL3_KEY ,DEP3_COL4 ,DEP3_COL5 ,DEP2_COL3 > ,DEP2_COL4 ,FIELD_TWO ,FIELD_THREE ,FIELD_FOUR > ,FIELD_FIVE ,FIELD_SIX ,FIELD_SEVEN > ,CHAR(FIELD_EIGHT,ISO) ,CHAR(FIELD_NINE,ISO) > ,FIELD_TEN ,TIMEZONE () FROM MAIN FULL OUTER JOIN DEP2 > ON DEP2_COL1_KEY = FIELD_ONE_KEY LEFT JOIN DEP3 ON > DEP3_COL1_KEY = DEP2_COL1_KEY AND DEP3_COL2_KEY = > DEP2_COL2_KEY ORDER BY COL1_KEY ,COL2_KEY > ,DEP3_COL3_KEY 00000024-00000198 1 0.04 0.04154 0.04 0.04668 -> D00026 0 EXECUTE IMME 1 0.04 0.04154 0.04 0.04668 > EXPLAIN PLAN SET QUERYNO=1 FOR SELECT > COALESCE(FIELD_ONE_KEY, DEP2_COL1_KEY) AS COL1_KEY > ,COALESCE(DEP2_COL2_KEY, DEP3_COL2_KEY) AS COL2_KEY > ,DEP3_COL3_KEY ,DEP3_COL4 ,DEP3_COL5 ,DEP2_COL3 > ,DEP2_COL4 ,FIELD_TWO ,FIELD_THREE ,FIELD_FOUR > ,FIELD_FIVE ,FIELD_SIX ,FIELD_SEVEN > ,CHAR(FIELD_EIGHT,ISO) ,CHAR(FIELD_NINE,ISO) > ,FIELD_TEN ,TIMEZONE () FROM MAIN FULL OUTER JOIN DEP2 > ON DEP2_COL1_KEY = FIELD_ONE_KEY LEFT JOIN DEP3 ON > DEP3_COL1_KEY = DEP2_COL1_KEY AND DEP3_COL2_KEY = > DEP2_COL2_KEY ORDER BY COL1_KEY ,COL2_KEY > ,DEP3_COL3_KEY 00000020-000001A8 1 0.04 0.04167 0.04 0.04925 -> D00026 0 EXECUTE IMME 1 0.04 0.04167 0.04 0.04925 > EXPLAIN PLAN SET QUERYNO=1 FOR SELECT > COALESCE(FIELD_ONE_KEY, DEP2_COL1_KEY) AS COL1_KEY > ,COALESCE(DEP2_COL2_KEY, DEP3_COL2_KEY) AS COL2_KEY
[ Top of Page | Previous Page | Next Page | Contents | Index ]