Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Jun 2004 @ 11:24:04 GMT


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


Subj:   Re: Collect stats and Group by difference
 
From:   Claybourne Barrineau

Shrinivas,

This is a bug being addressed by RFC 84623 and is scheduled to be fixed in V2R6.0. Today, basically, if a null exists in any field of a multi- column index or a multi-column statistic, then the respective columns are treated as having a null value from a statistics point of view. At our site, this has caused some significant performance issues. Once this is fixed, then your group by count should match your statistics count.


Hope this helps,

Clay



     
  <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