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.
|
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. |
The following table explains the options in the Set RAS tab.
|
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.
|
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. |
