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

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.