Adding Query Characteristic Classification Type - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
You can classify filters, meters, throttles, or workloads by query characteristics.
  1. From the ruleset toolbar, click Filters, Meters, 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 Analytics Database, multiple parameters are joined by AND.
  6. Click OK.