Defines the maximum size (in KB) of the plastic steps segment (also known as OptSeg).
64 through 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.
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.