Archives of the TeradataForum
Message Posted: Thu, 02 Oct 2003 @ 13:02:29 GMT
| Subj: || || Re: Plastic Steps |
| From: || || Geoffrey Rommel |
| ||Can someone explain what is meant by 'plastic steps'?|| |
See the SQL Reference, Vol. 2, esp. the section "Generator". I quote:
The Generator creates a series of directives for the AMPs that contain column and row information, but no literal data values. The steps,
called plastic steps, are later transformed into concrete steps by Apply. Plastic steps allow sets of values taken from the USING modifier
to be inserted during subsequent operations.
| ||We recently changed DBS Control setting MaxParseTreeSegs from 64 to 1000 and now we are receiving this error.|| |
That's a lot of parse tree segments, unless you are using Teradata Warehouse Builder or some other product that is generating gnarly SQL.
If you are, then the recommendation to increase the SegmentSize makes sense to me.