Archives of the TeradataForum

Message Posted: Fri, 15 Apr 2005 @ 14:59:10 GMT

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

Hi,

When I take a Explain Plan against any query which has more number of joins, there are some SPOOL space used for intermediate operations.

For eg: Spool-1, Spool-2 and Spool-7. How are these related and can I view the data's in the intermediate Spools after every operations.

Can anybody expalin about the Spool along with its number.

Regards,

Murugesh.

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