Re: Wrong cardinality estimates if group by (and possibly a hash join)
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: Laimutis.Nedzinskas@xxxxxx
- Date: Thu, 26 Apr 2012 07:42:27 -0700
This really isn't an issue with the group by cardinality as the output of
the GBY isn't input into anything other than the final result set.
The difference in the plans has to do with the forced materialization and
the change of the join type.
On Thu, Apr 26, 2012 at 5:30 AM, <Laimutis.Nedzinskas@xxxxxx> wrote:
>
> In Oracle 11.2.0.3 and 10.2.0.3 group by produces wrong cardinalities. See
> the inner hash join cardinality bellow.
>
--
Regards,
Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> |
linkedin <http://linkd.in/gregrahn>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
