Multistatement Requests | Teradata Vantage - 17.10 - Multistatement Requests - Advanced SQL Engine - Teradata Workload Management

Teradata Vantageā„¢ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)
Business intelligence tools, such as Tableau, group multiple SQL statements into one request. The Multi-Statement Request classification criterion lets you identify, isolate, and manage multistatement requests using the following options:
Option Description
Exclude Prevents multistatement requests from being included in a specific workload.
Include Splits multistatement requests into a distinct workload so you can manage them separately from shorter requests.
Threshold statement count Enter a value to define the minimum number of SQL statements that qualify as a multistatement request. The default is 2.

This classification criterion applies to workload, filter, and throttle rules and can be combined with all existing classifications.

TASM ignores the following special statements when counting the statements in a request:
  • BEGIN TRANSACTION (BT)
  • END TRANSACTION (ET)
  • COMMIT
  • NULL

The TDWMMSRCount field in DBC.QryLogV view shows the statement count in a multistatement request.