Archives of the TeradataForum
Message Posted: Wed, 03 Nov 2010 @ 10:31:44 GMT
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.
Prasad K K
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|