Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 Jun 2004 @ 16:07:39 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Collect stats and Group by difference
From:   Victor Sokovin

  In my case I do not have single NULL is any column of primary index. In my case I can see one more case for one column (one of field from Primary index) that GROUP BY is showing less number and COLLECT STATS showing more number.  

If you haven't done so already, you could try Dieter's script in

www.teradataforum.com/teradata/20040618_202707.htm ,

which should provide more details.

Is there anything unusual there for the tables you are talking about?



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023