Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Eliminating cartesian merge
Jonathan Lewis apparently said,on my timestamp of 29/09/2005 12:50 AM:
>
> As an experiment, you could try:
> alter session set "_complex_view_merging" = false;
>
> You could also try putting a no_merge hint into
> the query, perhaps using a global hints to reference
> objects inside the view.
>
>
I do believe that's one of the settings recommended for the pfile by Peoplesoft support.
-- Cheers Nuno Souto in sunny Sydney, Australia wizofoz2k_at_yahoo.com.au.nospamReceived on Wed Sep 28 2005 - 10:16:12 CDT
![]() |
![]() |