Displaying a "What" Parameter Histogram - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-10-13
dita:mapPath
awa1488824663126.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2514
lifecycle
previous
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.