Purpose
Determines whether Teradata Database uses dynamic parameterization of literals (DPL) when processing repeated nonparameterized requests.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Teradata Database 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 | Teradata Database 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 Topics
| For More Information on… | See… |
|---|---|
| Dynamic parameterization of literal values during transaction processing and optimization | Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142. |