Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2010 @ 10:31:44 GMT

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

Experts,

I am loading an empty table from four select SQL's and I am using MSR to achieve better performance. In all my select SQL, I have join of 9 columns, out of which for one join condition and I am using CAST function in the driven table. For the 9th join I am using a CASE statement to assign values in the driven table. Also I have an ordered analytical function used in the select.

When I run each one single, I don't face issue of spool space, but when I run the 4 SQL's as MSR, spool space is maxed out. I am Teradata 12

Could you please help me out of this problem.

Thanks,

Prasad K K

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