Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Jul 2006 @ 14:10:28 GMT


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


Subj:   Re: No more spool for user
 
From:   Victor Sokovin

  Both tables have around 550.000 records.  


  The spool space for the user is 50 GB. Any suggestion??  


I must admit that I have not looked at the query but want to make one suggestion anyway (perhaps not a good idea, in general).

You seem to have a decent size spool but how many AMPs have you got? If you run out of space on just one of them you will get the error message. Usually this happens when there is a high data skew = too much data resides on a small number of AMPs.

Try a search in the Forum's archives on "skew". You should find many useful threads. It *is* a big topic in Teradata.


Regards,

Victor



     
  <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