parallel hint with group by gives wrong results
- From: John D Parker <orclwzrd@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 11:53:48 -0800 (PST)
query with no parallel hint and parallel degree 7 set on some of the
tables(including table that is hinted) gives right answer but is "too slow"
query with parallel hint and no specified degree(ie default degree) and
parallel degree 7 set on some of the tables(including table that is hinted)
gives wrong answer by factor of default degree and is fast enough.
The query has a sum and a group by, the sum is off by multiple of the default
degree(24) when the parallel hint is given. Anyone know about any "features"
relating to sum/group by/parallel hint/default degree.
all help welcome.
john
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
Other related posts:
