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.