Plan Table Analysis
The Plan Table Analysis screen displays when you:
- Select a DBRM/Package on the SQL Analysis Summary screen (SQL Analysis Summary).
- Select a statement on the SQL Statement Selection screen (SQL Statement Selection Screen).
- Issue the XP line command in SQL Source Development and Analysis or select option 3 from the Host Variable Resolution screen. See ISPF-PDF-SQL-source-development-and-analysis for more information.
It displays the entire SQL statement and enables you to receive an access path analysis, explain detail, a predicate analysis, and catalog information for the SQL statement. Scroll to the previous or next SQL statements with the PREV and NEXT primary commands.
Plan Table Analysis Screen
OPTION ===> SCROLL ===> PAGE
SSID: DSN
1 - Access Path Analysis 4 - Object Information
2 - Explain Detail 5 - Cost Detail
3 - Predicate Analysis 6 - Function Detail
DBRM/Package QUERYNO Type DB2 Cost * PROCSU Access Type
------------- ------- ---- ----------- ------ ----------------
<SOURCE> 1 SELECT 5 17 Tablespace Scan
SQL Statement: 1 OF 1
SELECT *
FROM USERID.EMP
****************************** Bottom of data ******************************
OPTION
Enter the desired option.
1 | Displays an Access Path Analysis for the plan (Access Path Analysis Screen). |
2 | Displays the Explain Detail for the plan (Explain Detail Screen). |
3 | Displays a SQL Predicate Analysis for the plan (SQL Predicate Analysis). |
4 | Displays catalog information for the package (Table Information screen). |
5 | Displays Cost Detail information for the package (Cost Detail Information Screen). |
6 | Displays Function Detail information for the package (Function Detail Information Screen). |
This section provides information about the following topics: