Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow view needs optimization help

Re: Slow view needs optimization help

From: Jon Davis <jon_at_REMOVE.ME.jondavis.net>
Date: Tue, 31 May 2005 07:05:35 -0700
Message-ID: <Pa_me.160$Zt.5@okepread05>


I'm pretty new to Oracle, and I'm using TOAD. TOAD tells me that no execution plan tables exist. (??)

Jon

"Robert Klemme" <bob.news_at_gmx.net> wrote in message news:3g38ktF9u9bbU1_at_individual.net...
> Jon Davis wrote:
>> This might be too much hassle for most of you but someone might be up
>> for a good challenge. I need to figure out how to optimize this query
>> (at bottom of this post) for Oracle 9i.
>
> <snip/>
>
> Did you look at the execution plan? Did it give you any hints?
>
> robert
>
Received on Tue May 31 2005 - 09:05:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US