Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Jun 2004 @ 08:31:36 GMT


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


Subj:   Collect stats and Group by difference
 
From:   Sagare, Shrinivas

Hi,

I am getting difference in Statistics and Group by. Below is the explanation.

I have one table (say Table_R) which has around 26 million records. Its primary index is based on three fields A, B, and C.

If I am doing

     SELECT A, B, C FROM Table_R GROUP BY 1,2,3;

then I am getting result around 25,600,000.

If I am doing collect statistics on same fields then I am getting different result

     COLLECT STATS ON Table_R COLUMN (A, B, C);

then I am getting result as 25,220,211.

Can anybody tell me why its giving different result? And what's wrong?


Thanks in advance,

Shrinivas Sagare



     
  <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