Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Explain plan from hell
I have not seen that size before but I have seen in the terabyte range.
Looks like a little tuning may be in order : )
On Oct 21, 10:21 pm, "Muz" <themuzic..._at_gmail.com> wrote:
> Valentin Minzatu wrote:
> > Can you post the SQL as well?
>
> > I hope is not "SELECT 1 FROM dual;".
>
> > Cheers,
> > ValentinThe SQL is about 4 pages long, and comes from Oracle Warehouse Builder.
> I suspect that they forgot to tell OWB how to link various tables
> together, as there are eight (yes, 8) cartesians joins.
>
> Muz
Received on Sun Oct 22 2006 - 23:03:47 CDT