Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 21:41:00 GMT

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

Also note that the spool space is per user, not per query. If you have multiple queries running at the same time, the total spool used must be less than the max spool. If you exceed the max spool limit, all of the running queries will fail. Finally, the max spool is a per amp limit. If you have a 20 Gig limit on a 20 amp system, the max is 1 Gig on any one amp. A highly skewed join step could blow the spool limit on a single amp.

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