Adding Query Characteristic 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 query characteristics.
  1. From the ruleset toolbar, click Filters, Throttles, or Workloads.
  2. Select an item or create one.
  3. Click the Classification tab.
  4. Select a query characteristics criteria or add one.
  5. Choose from the following query characteristics criteria:
    Option Description
    Statement Type (Teradata Database 14.10 and later) Options are: DDL, DML, and SELECT. COLLECT STATISTICS. Any additional parameters are joined with AND.
    AMP Limits Includes or excludes queries that use all AMPs for filter rules.
    Multi-Statement Request Allows you to set the minimum number of SQL statements a request must have to be classified as a multi-statement request (a request with two or more SQL statements in a single request separated by semicolons). A request with that number of or more SQL statements is not considered equivalent to a single statement request. You can select the Exclude option to disallow a multi-statement request from getting into certain workloads.
    Estimated Step Row Count Specifies estimated minimum and maximum rows at each step.
    Estimated Final Row Count Specifies estimated minimum and maximum rows in the result set.
    Estimated Step Processing Time Specifies an estimated minimum processing time at each step.

    (Teradata Database 15.0 and later) Specifies an estimated maximum processing time at each step.

    (Teradata Database 15.0 and later) After entering a value, click the Tab key to see a conversion of the seconds into days, hours, minutes, seconds, and milliseconds (d+hh:mm:ss:ms).

    Estimated Total Processing Time Specifies estimated minimum and maximum total processing time. Longer or more complex queries have less accurate estimates.

    (Teradata Database 15.0 and later) After entering a value, click the Tab key to see a conversion of the seconds into days, hours, minutes, seconds, and milliseconds (d+hh:mm:ss:ms).

    Join Type Options in the Include Only list are: No Join, Any Join, Product Join, No Product Join, Unconstrained Product Join, or No Unconstrained Product Join.
    Full Table Scan Includes or excludes full table scans for all rows.
    Memory Usage (Teradata Database 14.10 and later) Specifies a minimum threshold for queries using excessive memory. Options are Increased, Large, or Very Large. These thresholds are defined in System settings in the Workload Designer view.
    Incremental Planning Includes or excludes queries that use incremental planning.

    Incremental Planning and Execution (IPE) executes single-row and scalar subqueries and uses the incremental results to optimize processing of the main query. For more information, see Teradata® Database SQL Request and Transaction Processing.

    In Teradata Database, multiple parameters are joined by AND.
  6. Click OK.