Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Jan 2002 @ 15:50:42 GMT


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


Subj:   Re: What happens to Collect Stats & Metadata while exporting/archiving?
 
From:   Robert A. Flohrschutz

Dave,

I asked a similar question since we are planning a redistribution after adding nodes. The answer from NCR was that we had to run Collect Statistics to get current distribution data. My assumption is that the optimizer gets amp distribution from the collect stats and if you go to a different configuration the distribution will be different even with the same data.

Bob



     
  <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