Viewing Index Recommendations for Tables
Use Teradata VE to view index recommendations information for a table from a previous index analysis operation.
To view index recommendations for tables
1 After loading and analyzing a plan or group of plans:
a Right-click on in a plan.
b Select Recommendations from the shortcut menu.
The Recommendations for table dialog box appears.
Figure 52: 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 |