Tactical queries are short, critical queries that have defined service-level goals (SLGs). Workload management SLGs define criteria for the response time goals for the queries. Many times, tactical queries need to complete in less than a second. When a query is classified as tactical, all available resources are used to process it, enabling it to meet the SLGs.
The following is an overview of the process:
Scenario assumptions
This scenario assumes you already have the following set up:
- Teradata Database version: 16.00
- Operating system: SLES 11
- System: PROD1
- Ruleset: SLG