-
Problem with group by Clause
There is strange problem with group by results
when running in parallel
the table recs have nearly 180 million records
insert into tab1
select /*+parallel(a,8)*/
transcode, filename, rectype, count(*), sum(charge), sum(units)
from recs
group by transcode, filename, rectype
the above is giving some strange reults for some files
for example the output of filename "XYZ" is
DBFG, XYZ, 10, 2000, 3000, 10000
DBFG, XYZ, 20, 2000, 3000, 10000
DBFG, XYZ, 30, 2000, 3000, 10000
when executed as
insert into tab1
select /*+parallel(a,8)*/
transcode, filename, rectype, count(*), sum(charge), sum(units)
from recs
where recs.filename = 'XYZ'
group by transcode, filename, rectype
the output is
DBFG, XYZ, 10, 3000, 6000, 12000
DBFG, XYZ, 20, 5000, 7345, 13467
DBFG, XYZ, 30, 2000, 3000, 10000
this output is correct when comparing to the previous one
I could not able to recognize the actual problem, please can someone help me
Last edited by tabreaz; 02-08-2006 at 12:24 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|