Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does Optimizer use P.A.T to calculate cost..?
Gints Plivna wrote:
> Bigger value of pga_aggregate_target makes cost of hash_joins smaller,
> as you can see in my previous example. So probably instead of nested
> loops you get hash joins or merge joins now.
Yeahh forget to mention that obviously hash joins or merge joins causes full scans of table or fast full scans of indexes.
Gints Plivna
http://www.gplivna.eu
Received on Fri Oct 27 2006 - 08:37:45 CDT