Plan Table Rows panel

FM/Db2 displays the Plan Table Rows panel if you:
  • Select option L (List plan table rows) on the Explain Utilities panel, or
  • Enter the EXPLAIN primary command on the Enter, Execute and Explain SQL Statements with the Show results option selected.

Use this panel to display rows from a plan table.

Figure 1. Plan Table Rows panel (collection ID format)
  Process   Options   Utilities   Help
 FM/Db2 (DFG2)                  Plan Table Rows                 Row 1 to 1 of 1

          Query Q  Collect. Progname Pl M Ac M  I T  Table
 C       Number Bl (COLLID) (Packg)  No T Ty Co O No Owner  + Table Name       +
              * *  *        *        *  * *  *  * *  *        *                 

             42 1  FMN2APR4 FMN2D2IO 1  0 R  0  N 1  SYSIBM   SYSTABLES
 ******************************* END OF Db2 DATA *******************************










 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
The Plan Table Rows panel shows you rows from a plan table:
C
Input field where you can enter one of the following line commands:
D
Delete row
DK
Delete rows for package
DP
Delete rows for plan
DQ
Delete rows for query number
FR
Show function table rows. FM/Db2 displays the Function Table Rows panel (not shown).
I
Interpret EXPLAIN data
IH
Insert optimizer hint
K
Show package
M
Show DBRM
P
Show plan
SR
Show statement table rows. FM/Db2 displays the Statement Table Rows panel (see Statement Table Rows panel).
T
Show table
UH
Update optimizer hint
X
Show index
Query Number
A number that identifies the SQL statement.
Q Bl
Query block number: the number reflects the query's order of appearance in the EXPLAIN statement.
Collect.
Collection ID or blank for dynamic EXPLAIN. This information only is displayed for the COL format of the panel.
Applname
PLAN name or blank for dynamic EXPLAIN. This information only is displayed for the PLAN format of the panel.
Hint ID
Optimization hint ID or blank for dynamic EXPLAIN. This information only is displayed for the HINT format of the panel.
Progname
DBRM/package name. This information only is displayed for the COL and PLAN formats of the panel.
Hint Used
The optimization hint used or blank for dynamic EXPLAIN. This information only is displayed for the HINT format of the panel.
Pl No
Plan number. Indicates order in which the statement is run.
M T
Method: Join method that is used.
Ac Ty
Access type. Method of accessing the table.
M Co
Matching columns. Number of index keys used in an index scan.
I O
Index only. Whether only the index is accessed in this step.
T No
Table number. Position of the table in the statement.
Table Owner
Owner of the table being accessed.
Table Name
Name of the table being accessed.

Parent panels

Child panels

To display this panel… Use/do this
EXPLAIN Interpretation panel Line command I
Set Optimizer Hint panel Line commands IH, UH
Application Packages panel Line command K
Statement Table Rows panel Line command SR
Tables, Views and Aliases panel Line command T

Related tasks

Related references