You can enter "++" (or the Enter key) on any line to display a pop-up window containing additional information.
A sample detail window for this report is shown below (shown in three scrollable screen segments).
File View Navigate Help +---------------------------------------------------------------------------+ | More: + | | DB2 EXPLAIN Data for Selected Row | | | | Block number 0003 | | Plan number 0001 | | Join method None | | Table creator USER4 | | Table name MAIN | | Access type Table space scan | | Matching columns 0 | | Index creator n/a | | Index name n/a | | Index only No | | Merge join columns 0 | | Correlation name T3 | | Page range screening n/a | | Join type n/a | | Query block type SELECT | | Direct row access n/a | | | | Sort New Composite | | Unique No No | | Join No No | | Order by No No | | Group by No No | | | | Lock mode Intent Share | | Prefetch Pure sequential | | Function evaluation After data retrieval and sorting | | Multiple index operation sequence no. 0 | | | | Parallelism Information: | | Number of tasks 0 | | Group identifier 0 | | Join degree 0 | | Join group id 0 | | Sort composite group id 0 | +---------------------------------------------------------------------------+
File View Navigate Help +---------------------------------------------------------------------------+ | More: - + | | Sort new table group id 0 | | Parallelism mode n/a | | | | | | Descriptive Names Mapped to PLAN_TABLE Column Names | | | | Descriptive Name Column Name | | Block number QBLOCKNO | | Plan number PLANNO | | Join method METHOD | | Table creator CREATOR | | Table name TNAME | | Access type ACCESSTYPE | | Matching columns MATCHCOLS | | Index creator ACCESSCREATOR | | Index name ACCESSNAME | | Index only INDEXONLY | | Unique SORTN_UNIQ, SORTC_UNIQ | | Join SORTN_JOIN, SORTC_JOIN | | Order by SORTN_ORDERBY, SORTC_ORDERBY | | Group by SORTN_GROUPBY, SORTC_GROUPBY | | Lock mode TSLOCKMODE | | Prefetch PREFETCH | | Function evaluation COLUMN_FN_EVAL | | Multiple index operation sequence no. MIXOPSEQ | | Number of tasks ACCESS_DEGREE | | Group identifier ACCESS_PGROUP_ID | | Join degree JOIN_DEGREE | | Join group id JOIN_PGROUP_ID | | Sort composite group id SORTC_PGROUP_ID | | Sort new table group id SORTN_PGROUP_ID | | Parallelism mode PARALLELISM_MODE | | Merge join columns MERGE_JOIN_COLS | | Correlation name CORRELATION_NAME | | Page range screening PAGE_RANGE | | Join type JOIN_TYPE | +---------------------------------------------------------------------------+
File View Navigate Help +---------------------------------------------------------------------------+ | More: - | | Query block type QBLOCK_TYPE | | Direct row access PRIMARY_ACCESSTYPE | +---------------------------------------------------------------------------+
[ Top of Page | Previous Page | Next Page | Contents | Index ]