SQL Plan Selection
The SQL Plan Selection screen (see the following figure) displays when a Plan object type is selected on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen). This screen is only displayed when the catalog contains more than one plan matching the specified object name. Otherwise, the DBRM/Package Selection screen (DBRM/Package Selection Screen) displays. On this screen you can select a plan to be analyzed or explained.
SQL Plan Selection
CMD
Specify the line command to be performed on the selected plan.
S | Displays detailed DBRM/Package information for the selected plan. The DBRM/Package Selection screen (DBRM/Package Selection Screen) displays. |
X | Performs an Explain of the entire plan. If you entered 1 for online processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the SQL Analysis Summary screen (SQL Analysis Summary) displays. If you entered 2 for batch processing on the SQL Plan Analysis Specification screen (SQL Plan Analysis Specification Screen), the Batch Plan Analysis Reports window (Batch Plan Analysis Reports Window) displays. You may explain more than one plan by entering multiple X line commands. See Explaining-Objects-in-Batch for more information. |
Sorting Plan Entries
The SORT primary command can be used to change the order in which the plan entries are displayed. Multiple column names are not accepted. The selected columns are sorted in ascending sequence. The valid column names that can be used with the SORT command are listed below. Abbreviations are noted within parentheses.
- Name (NA)
- Creator (CR)
- Boundby (BO)
- Date (DA)
- Time (TI)
For example, to sort the display by the bind time, enter the command SORT TI.
Related topics