Query Characteristic Classification Type - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
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.