Query Characteristic Classification Type - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem

The query characteristic classification type describes a query by answering such questions as what does the query do and how long will the query run.

Consider the following when using query characteristics to classify information:
  • A query characteristic type can only be used once in each rule. After it is used, it no longer appears in the list.
  • The query characteristic and utility types are mutually exclusive. If you use one, the other option is not available.
  • A query characteristic type can have multiple parameters. The Statement Type parameter is joined to any additional parameters with AND. Multiple parameters are joined by AND.
  • Some characteristics have less than (or equal to) and greater than (or equal to) values that can be set independently.