Archives of the TeradataForum

Message Posted: Wed, 28 Dec 2005 @ 13:00:16 GMT

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

Number of sessions has no relation to skewed spool (for any utility).

FastExport builds the entire answer set in spool and redistributes it before returning data. The good news is that this process effectively eliminates skew during the response phase; the bad news is that your spool space limit must be at least twice as large as the answer set.

As you noted, OUTLIMIT is applied on the client side as data is being returned. You'll need either need a higher spool space limit or a SQL change (e.g. added WHERE criteria) to limit the size of the result set.

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