Adding Query Characteristic Classification Type - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
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.
    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.

    For Teradata Database 15.0 and later, specifies an estimated maximum processing time at each step.

    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 and 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.