|
Get Execution Plan
|
Enabled if the Connection Profile is connected. The command executes an EXPLAIN command for the SQL Statement and displays the execution plan in the Execution Plan view. If you selected the Text plan type, the Execution Plan is displayed as text. If you selected the Graphic plan type, the INSERT EXPLAIN command executes and inserts the plan steps in the QCD database. The Execution Plan is then displayed in a tree node hierarchy. |
|
Get Execution Plans with Statistics
|
Enabled if the user's connection profile is connected and the user has chosen to use the Graphic plan type, in the option. The command executes an INSERT EXPLAIN WITH STATISTICS command for the SQL Statement. The statistic data is placed in the TableStatistics table within the QCD database. The statistics data is then gathered by running a HELP STATISTICS command with the given table name, column name, and query ID. HELP STATISTICS retrieves the information from the TableStatistics table. |
|
Compare Execution Plans
|
Enabled if the Connection Profile is connected, and you selected to use the Graphic plan type in the option. The command displays a list of the execution plans contained in the QCD (Query Capture Database)for the given profile. The list is displayed in the Teradata View. The name of the profile displays in parenthesis within the Execution Plan List tab label. |