Advanced Button - 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 Advanced button on the What-If Analysis dialog box opens the Analysis Options dialog box to modify the statistics collected for the tables in the workload during the What-if analysis. The dialog box has three tabs.

The following table explains the options in the Set Costs tab.

 

Table 21: Analysis Options Dialog Box: Set Costs Tab Description 

Option

Description

Cost Tag

Selects the cost tag for which the cost parameters must be set.

Comment

Shows the comment associated with the cost tag.

Level

Session: Sets the cost parameters at session level.

IFP: Sets the cost parameters at IFP level.

System: Sets the cost parameters at system level.

Set/Reset

Set: Sets the cost parameters.

Reset: Resets the cost parameters.

Figure 8: Analysis Options Dialog Box: Set Costs Tab

The following table explains the options in the Set RAS tab.

 

Table 22: Analysis Options Dialog Box: Set RAS Tab Description 

Option

Description

Database Name

Displays the Teradata Database name in which the table is present.

Table Name

Displays name of the table on which the random AMP samples must be set.

RAS Tag

Displays the RAS tag for the table.

Level

Sets RAS level at either the session or system level.

Set/Reset

Click to set the Set or Reset option.

Select All

Click to select all RAS tags.

The following table explains the options in the Set Statistics Samples tab.

 

Table 23: Analysis Options Dialog Box: Set Statistics Samples Tab Description 

Option

Description

View/Edit Statistics Samples

Sets the option to view/modify the statistics samples for the tables in the workload. The default is Yes.

Set Defaults

Sets the default sample size for tables with the specified cardinalities.

Figure 9: Analysis Options Dialog Box: Set Statistics Samples Tab