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

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: