Archives of the TeradataForum

Message Posted: Tue, 25 Jan 2005 @ 22:27:08 GMT

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

Rick:

There was a thread on this last year. You can get more details in the archives, but basically Paul Sinclair from NCR indicated the the SPOOL is distributed based on its next usage, like for a join it would be distributed on the join column(s). This actually came up resulting from a discussion on the spooling of derived tables in spool files.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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