Query Characteristic Classification Type

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
User Guide

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.