A sample report is shown here:
File View Navigate Help +--------------------------------------------------------------------------------+ |DB2 EXPLAIN (0167/CICS23A) Row 00001 of 00010 | |Command ===> __________________________________________________Scroll ===> CSR | | | | Blk Plan Mix Join Acc Match Index Sort New Sort Comp Table | | Num. Num. Op Mthd Type Cols Only U J O G U J O G Name | | | | 0001 1 0 0 R 0 N N N N N N N N N MAIN | | 0001 2 0 3 0 N N N N N Y N N N | | 0002 1 0 0 R 0 N N N N N N N N N DEP1 | | 0003 1 0 0 R 0 N N N N N N N N N MAIN | | 0004 1 0 0 R 0 N N N N N N N N N DEP2 | | 0005 1 0 0 R 0 N N N N N N N N N MAIN | | 0005 2 0 3 0 N N N N N Y N N N | | 0006 1 0 0 R 0 N N N N N N N N N DEP1 | | 0007 1 0 0 R 0 N N N N N N N N N MAIN | | 0008 1 0 0 R 0 N N N N N N N N N DEP2 |
[ Top of Page | Previous Page | Next Page | Contents | Index ]