Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 19:39:23 GMT

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

<-- Anonymously Posted: Thursday, April 12, 2007 13:20 -->

Most probably the plan before and after collect stats are different. Before stats small table may be duplicated and large table is built local or accessed directly. May be after stats plan would have changed to redistribute both the tables. If you post the explain we can easily figure out the cause for out of spool.

Regards

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