Adding Target Classification Type

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
You can classify filters, throttles, or workloads by targets such as database, table, view, macro, stored procedure, function, or method. If some objects are not included in the list for a database, they can be manually included as a match string.

For Teradata Database 15.0 and later, you can also select targets from external QueryGrid servers, such as Aster or Hadoop servers.

  1. From the ruleset toolbar, click Filters, Throttles, or Workloads.
  2. Select an item or create one.
  3. Click the Classification tab.
  4. Select Target as the classification criterion and click Add.
  5. Select a Target Type from the list.
  6. Do one of the following, depending on the target type:
    Target Type Action
    Table, View, Macro, Stored Procedure, Function, or Method Select the database that contains the target.
    QueryGrid Server (for Teradata Database 15.0 and later) Select the QueryGrid server type.
  7. Do at least one of the following:
    • Enter a match string and use the Include and Exclude buttons to add the match string. A match string can contain ? to match exactly one character or * to match zero or more characters.
    • Select items from the list and use the Include and Exclude buttons to create your classification criteria. If there are more than 500 items, use the filter box to locate the items you want to select.
  8. [Optional] For databases, tables, views, macros, and stored procedures, click next to an item in the Selected list, and choose from the following:
    Subcriteria Description
    Full Table Scan Includes or excludes all-row scans
    Join Type Selects no join or a join type
    Estimated Step Row Count ≥ Specifies the estimated minimum rows at each step
    Estimated Step Row Count ≤ Specifies the estimated maximum rows at each step
    Estimated Step Processing Time ≥ Specifies the estimated minimum processing time at each step
    Estimated Step Processing Time ≤ (Teradata Database 15.0 and later) Specifies the estimated maximum processing time at each step
    Estimated percent of table blocks accessed during the query ≥ (Table target databases and Teradata Database 15.0 and later) Specifies the estimated minimum percent of table blocks accessed during the query
    If multiple subcriteria are added to a single item, all subcriteria conditions must be true in order for the query to be classified into the rule.
    1. [Optional] In Teradata Database 15.0 and later, select a statement type (applies only to Table target databases).
    2. Click OK. Next to target items containing subcriteria, appears.
  9. Click OK.