Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Multi statement request and spool space
 
From:   Prasad Kavil Kambrath

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016