Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Jul 2003 @ 14:44:58 GMT


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


Subj:   Predicting the space needed for spool
 
From:   Jim Renner

I have a collegue who is having issues with the population of a very large table. Seems his spool space is blowing up. I have made the suggestions that his data might be skewed, and joining on primary indexes and such, however his initial question whas how to calculate the amount of space they need for a set query.

So, Any suggestions?

I am thinking there has got to be something with row-count, index type, join columns, and data type that would work.

Thank you for your assistance.



     
  <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