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).
-
Right-click
in a plan.
-
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