Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Feb 2008 @ 09:33:31 GMT

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

Subj:   Re: High confidence in Explain
From:   ulrich arndt

Hi Martin,

one reason could be that new data had been loaded to the table after the stats had been collected. Stats are not refreshed automatically and therefore the recommendation is that you should recollect stats if ~5% of the data changed. But this is not an absolut recommendation. As it is only required to refresh the stats in case the demographic changed - which might have happened in your case.


  <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: 23 Jun 2019