15.00 - StepsSegmentSize - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

StepsSegmentSize

Purpose  

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.