Displaying a "What" Parameter Histogram - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities
  1. From the Candidate Workloads tree, expand the workload to be analyzed.
  2. Select Analyze Workload. The Analyze Workload window appears.
  3. Select the appropriate “what” options in the Workload Distribution Parameters list.
    See the table following step 3 in Analyzing Workloads Based On “Who” Parameters for more information about Analyze Workload window options.
  4. Click Perform Analysis to analyze the selected workload with chosen options. By default, the Analyze Workload window creates an equal-width balanced histogram, dividing the total selected distribution parameter into the number of buckets specified in the Top N Value field. Each bucket contains equal amounts of the selected distribution parameter and the total query count lies in that bucket.
  5. To view the corresponding equal-height histogram, click the Switch to Equal-Height Histogram button on the Analyze Workload tab. You can also right-click the histogram itself and select Equal-Height Histogram from the menu that appears.


  6. To view the Equal-Height Distribution report associated with the histogram, select View Equal-Height Table.

    The table appears and is similar to the one shown in the figure below.