Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow view needs optimization help
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