Dynamic Embedded SQL Statements | Teradata Vantage - Dynamic Embedded SQL Statements - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
vqj1592443206677.ditamap
dita:ditavalPath
vqj1592443206677.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantageā„¢

Dynamic SQL is a facility that permits an interactive user to submit SQL statements dynamically to an application written using embedded SQL or stored procedures.

When contrasted with dynamic SQL, the facilities ordinary SQL provides are sometimes referred to as static SQL.

Always use static SQL if possible, because dynamic SQL has a significant processing overhead that often impedes system performance.