Performing a Partition Analysis - Teradata Index Wizard

Performing a Partition Analysis

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

To start a Partition analysis

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.