This section discusses the setting of Teradata WA options, allowing for configuration of application settings.
The Show Distinct Count option allows the display of the number of distinct value counts for all possible correlation parameters. It also allows the display of total available ranges for distribution parameters.
This feature provides an automated, intermediate analysis step to identify distinct value counts within all possible correlation parameters as well as a “heterogeneous” identification metric for the workload in general.
- User Name (24)
- Application (1)
- Account Name (1)
- Client Addresses (2)
- Query Band
- Function (3)
- Urgency (1)
- AggLevel (8)
- Estimated Processing Time (0 to 1000 seconds)
- AMP Count (0 to 1)
For example, with respect to the distinct value counts, a workload could display the following characteristics.
In this example, the DBA benefits from the knowledge that there is only one distinct Application or Account, which run at the same urgency, so the effort in identifying a correlation against a different Application, Account, or other urgency values would be a waste of time.
The opportunity for correlation does exist for Users (24), Function (3), and Agglevel (8), so those options could be further analyzed in a trial and error method. The same process is applicable for selecting a distribution parameter because the Estimated Process Time has a large range, and drill-down required for analysis and classification.
The Show Distinct Count option is useful in avoiding unnecessary trial and error analysis by providing a direct analysis of distinct value counts in a workload. The distinct value counts are updated after each level of analysis. See Using Deep Drill-Down and Refinement for Workload Analysis.