Analyzing Plans - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Analyzing Plans

Use this procedure to analyze a current plan or a group of plans, performing index and partition analyses separately or simultaneously.

Note: This feature is available only for plans captured in QCD.

To analyze a current plan or a group of plans

1 Select a plan or group of plans for analysis:

  • To analyze a plan:
  • i Load the plan.

    i Load the plan.

    ii Right-click anywhere on the background.

    iii Click Index Analysis from the shortcut menu.

    Figure 48: Index Analysis
  • To analyze a group of plans:
  • i Load the plans.

    i Load the plans.

    ii Click .

    The Select Plans for Analysis dialog box appears.

    iii Under Available Execution Plans, select the plans to analyze.

    iv Add selected plans to the Selected Execution Plans list.

    v Click Next.

    The Define dialog box appears. A unique workload name and index recommendation tag are generated internally, by default.

    Figure 49: Define Workload

    2 [Optional] To change the default, type a different workload name and index recommendation tag.

    3 Under Analysis Type, select each type of analysis to perform:

  • Initiate Index Analysis
  • Initiate Partition Analysis
  • 4 [Optional] If Initiate Index Analysis is selected in step 3, click Parameters to further define the index analysis.

    The Index Analysis Parameters dialog box appears.

    Figure 50: Index Analysis Parameters

    5 [Optional] Set parameters to determine index recommendations.

    For information on these parameters, refer to Teradata Index Wizard User Guide B035-2506 and read the topic Advanced Index Parameters.

    6 Click OK to close this dialog box and return to the Define dialog box.

    7 [Optional] Enter a number in the Time Limit box.

    8 [Optional] Select the Apply modified statistics check box to use the modified statistics information during the analysis.

    Note: The Apply modified statistics check box is available only when the Initiate Index Analysis check box is selected.

    9 [Optional] Select the Delete after use check box to remove the workload and any recommendations after the analysis.

    10 Click Analyze.

    All selected analysis types are performed. A progress indicator appears showing the elapsed time since the start of the analysis. To terminate the analysis, click Abort.

    The analysis is performed for the current plan. The resulting recommendations are shown in an Index Recommendation report. The index analysis provides the recommended secondary index for each table and the partition analysis provides partition recommendations for each table when a recommendation can be made. This report provides decision‑making information to determine whether a recommendation is appropriate. The report also suggests indexes that can be dropped. For more information about the columns in this report, refer to Teradata Index Wizard User Guide B035-2506 and read the topic Index Recommendation report.

    Figure 51: Index Recommendation Report