Archives of the TeradataForum

Message Posted: Thu, 02 Oct 2003 @ 13:02:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>