Adding Query Characteristic Classification Type

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
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 Options are: DDL, DML, and SELECT. COLLECT STATISTICS is available in Teradata Database 14.10 and later. Any additional parameters are joined with AND.
    AMP Limits Includes or excludes queries that use all AMPs for filter rules in Teradata Database 13.10 or later.
    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 in Teradata Database 13.10 or later and an estimated maximum processing time at each step in 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) in Teradata Database 15.00 and later.

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

    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) in Teradata Database 15.00 and later.

    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 Specifies a minimum threshold for queries using excessive memory in Teradata Database 14.10 or later. 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 SQL Request and Transaction Processing.

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