16.20 - Macros and Tactical Queries - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)
Macros can be a very effective method of performing tactical queries. The pros and cons of using macros to perform tactical queries in various applications and application workloads are described in detail elsewhere:
  • See Teradata Vantage™ - Database Design, B035-1094 for further information about using macros to perform tactical queries.
  • See Teradata Vantage™ SQL Data Manipulation Language , B035-1146 , for a comparison of the relative efficiencies of macros and stored procedures for performing tactical queries.