17.10 - EnableDynamicParameterization - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Determines whether Vantage uses dynamic parameterization of literals (DPL) when processing repeated nonparameterized requests.

Field Group

General

Valid Settings

Setting Description
TRUE Vantage attempts to produce and reuse generic query execution plans for similar, nonparameterized queries that differ only in literal values in WHERE and ON clauses.
FALSE Vantage does not reuse generic query execution plans for nonparameterized queries that differ only in literal values in WHERE and ON clauses.

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

  • When dynamic parameterization is enabled, and eligible nonparameterized requests differ only in the eligible literal values used in the predicates of WHERE and ON clauses, DPL logic in the Parser automatically parameterizes these literal. This allows the Parser to reuse a cached generic execution plan for such queries, and speed up processing.
  • Teradata recommends enabling this feature if you have several closely similar nonparameterized requests that would benefit from this type of processing. DPL can improve database query performance in proportion to the number of similar database requests.

Related Information

For More Information on… See…
Dynamic parameterization of literal values during transaction processing and optimization Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.