17.10 - Design Issues for Tactical Queries - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval

The majority of the topics covered by this document apply to designing for strategic, or decision support, queries. Because you can also run your operational data store on Vantage, this section highlights some of the design issues you must consider when implementing a physical design to support mixed workloads of both strategic and tactical queries.

The document discusses other material related to more specific design issues for tactical queries in Primary Index, Primary AMP Index, and NoPI Objects and Join and Hash Indexes.

The section does not make suggestions about scheduling job priorities to achieve an optimal mix of strategic and tactical workloads for your system, nor does it describe the various locking issues associated with tactical queries.

See Teradata Vantageā„¢ - SQL Request and Transaction Processing, B035-1142 for information about lock management for tactical queries.