Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 12:27:03 GMT


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


Subj:   Re: How much statistics to collect
 
From:   Martin O Brien

As far as I know dynamic random amp sampling is only used when there are no stats on the table. If there are stats on lets say the primary index then Teradata uses default stats for the rest of the columns ( which can be dangerous for "not very unique columns").



     
  <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