Archives of the TeradataForum
Message Posted: Wed, 23 Jun 2004 @ 08:31:36 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|