Archives of the TeradataForum

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

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

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>>