Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 07 Mar 2002 @ 15:51:14 GMT


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


Subj:   Re: Users Having Spool Space Problems Under V2R4.1
 
From:   Adam DeYoung

I'd try dropping and recollecting statistics - first on the smaller information/dimension tables, then the history tables. We encountered this problem going to a newer version a while back. The parser had new capabilities and our old-version statistics did not provide enough information. The parser fell back to random AMP sampling and developed some bad join plans per the EXPLAINs. Recollecting statistics gave it the necessary info and it behaved as expected again.


Hope this helps,

Adam



     
  <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