Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Apr 2007 @ 14:20:45 GMT


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


Subj:   Re: Out of Spool after Collecting Statistics
 
From:   Adurthy, Sri Krishna K

Hi

the Spool Space Errors might be not due to the stats collection. Stats Collection only enables the optimizer to select the most Cost efficient way of getting a solution .

The Spool space error may be due to any one of the Following factors

1. Skewness. - once the Data gets into the spool , the Data might be skewed , and one of the amps might run out of the spool space , also the joins happening on non frequently used columns , or having highly non unique values might be a reason for skewness

2. more no of queries from same user - more no of queries being executed by the same user , using the same spool area , and thus giving the spool space error

3. unnecessary redistribution of data (check for the explain plan and eliminate them if possible )


Thanks

Adurthy Sri krishna
Teradata DBA
AIM ( E.I.W)
Standard Bank Of South Africa



     
  <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: 15 Jun 2023