17.10 - StepsSegmentSize - 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)

Defines the maximum size (in KB) of the plastic steps segment (also known as OptSeg).

Field Group

Performance

Valid Range

64 through 1024 KB

Default

1024 KB

Changes Take Effect

After the DBS Control Record has been written. Any plastic step generation operations in progress at the time of the change are not affected.

Usage Notes

When decomposing a Teradata SQL statement, the parser generates plastic steps, which the AMPs then process.

Large values allow the parser to generate more SQL optimizer steps that the AMPs use to process more complex queries.

Set this field to a small number to limit the query complexity.