Re: Statement Tunning

Angela,

There is no real way to save execution plans like in Oracle 8i. The best that you can do is to use hints and RULE based optimization. This way, you will know which execution plan you are pointing the optimizer to.

HTH,
Brian

Angela Okpala wrote:
>
> 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???
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================