Re: Statement Tunning

From: Jack <No_at_Mail.Please>
Date: Mon, 23 Apr 2001 11:46:51 +0100
Message-ID: <pKTE6.21$3Z1.29@news1-hme0>

Sorry to BUTT in but why don't you just drop your new index? Should clear the problem.

"Angela Okpala" <A.Okpala_at_DeutschePost.de> wrote in message news:997vnk$86q2_at_ppd00021.deutschepost.de...
> Could anybody out there tell me if there is a way that i could save an
> Execution Plan using Oracle7.3.4. We added a new Index to an existing
table
> and it seems that when Oracle uses this new Index, the execution time
takes
> longer, which means using the old access path would be a better option.
> However, I know with Oracle8i, this could be done through using 'stored
> outlines'. I just dont know, how to do it with Oracle version 7.3.4. Any
> ideas???
>
>
>
>
Received on Mon Apr 23 2001 - 05:46:51 CDT