Viewing Index Recommendations for Tables

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K
Use Teradata VE to view index recommendations information for a table from a previous index analysis operation.

Use this procedure after loading and analyzing a plan or group of plans (see Analyzing Plans to Improve Performance).

  1. Right-click in a plan.
  2. Select Recommendations from the shortcut menu.

    The Recommendations for table dialog box appears.

    Recommendations for Table

    Box Name Description
    Workload Name of the workload used to obtain the index recommendations
    Table Name Table name
    Index Type Recommended-index type
    Estimated Cost Estimated cost to create the index in the database
    Recommendation Tag Index-name tag used while analyzing the indexes
    Index DDL DDL text used to create or drop the recommended indexes
    Stats DDL DDL statements used to collect the statistics recommended for improving the plan performance