Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 18:06:50 GMT

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

Spools are released as part of last step that it is used. For your understanding you can trace any explain for the word LastUse for spools.

A simple example:

........
We do an all-AMPs JOIN step from TEST.t1 by way of an all-rows scan with no residual conditions, which is joined to Spool 2 (Last Use) by way of an all-rows scan.
......

If all of them are marked properly, giving these details, you can open a ticket with NCR.

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