15.00 - Chapter 16 Design Issues for Tactical Queries - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

The majority of the topics covered by this manual apply to designing for strategic, or decision support, queries. Because you can also run your operational data store on Teradata Database, this chapter 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 manual discusses other material related to more specific design issues for tactical queries in “Chapter 9 Primary Indexes and NoPI Objects” on page 261 and “Chapter 11 Join and Hash Indexes” on page 499.

The chapter 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 Utilities: Volume 2 (L-Z) for a description of the Priority Scheduler utility and SQL Request and Transaction Processing for information about lock management for tactical queries.