Performing a Partition Analysis - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities

The Partition Analysis option starts a new analysis using the information from the current workload. The following steps explain how.

1 Select Analysis > Partition Analysis.

The Partition Analysis dialog box appears.

Note: If a workload was created prior to this analysis, the workload information is already in place when the dialog box opens. Check to ensure the desired workload is loaded.

2 Click Select All and Deselect All to choose the tables from the list.

By default, Index Wizard automatically selects all tables.

Note: To view the demographics of a table, right-click the Table Name column under Select Table, and click Data Demographics. This opens the Data Demographics applications. For more information, see Chapter 12: “Data Demographics.”

3 Name the recommendation using the Recommendation Tag box.

4 To save the recommendation to a file, select the Save Recommendations to File box and enter or browse to a file.

5 [Optional] Enter a time in minutes in the Time Limit box to set additional recommendation parameters.

6 Click OK to start the analysis. To abort the analysis, click Abort in the Analysis in Progress dialog box.

When the analysis is complete, the Partition Analysis Summary dialog box appears. This dialog box shows the results of the analysis.

The following table describes the Partition Analysis dialog box.

 

Option/Group

Description

QCD Name

If you created a workload prior to performing this analysis, the QCD is already in this field.

If no QCD name appears, click to view the available QCDs from the drop-down menu.

Workload Name

If you created a workload prior to performing this analysis, the workload is already in this field.

If no workload name appears, click to view the available workloads from the drop-down menu.

Workload Statements Spreadsheet

This shows the queries used in the current workload. Specifically the spreadsheet shows the Query ID, Frequency, and Statement Text.

Select Tables

Shows a spreadsheet of the tables selected to be analyzed. The columns include Database Name, Table Name, Statement Access, Row Estimate, and Existing Indexes.

Select All\Deselect All

Use these buttons to select or deselect all the statements in the Select Tables section. To select a single table, click the table in the spreadsheet.

Recommendation Tag

Use this option to give the index recommendation a tag.

Save Recommenda-tions in Files

Use this option to save the recommendations to a file.

Time Limit

Enter a time in minutes when the analysis will be performed. By default there is no time limit. The maximum time limit that can be set is 2880 minutes.

When the analysis is complete, the Index Recommendation Report appears. For more information, see “Index Recommendation Report” on page 116.