Re: View performance problem

Any idea why the performance last week was fine and now this week it is as slow as molasses. Nothing has changed. No data has been added. No changes to indexes or views. Why would the Optimizer all of a sudden choose a different access path.

Terry

"Andrew Velichko" <andrew_velichko_at_yahoo.com> wrote in message news:tDfV5.73734$Z2.999471_at_nnrp1.uunet.ca...
> Hi Terry!
>
> Did you use any hints in the query?
> They may be very helpful to build desired and fast execution plan.
> Plus this plan will be independent of Oracle Optimizer which
> sometimes doesn't work well (for instance, you forgot to collect
> statistics and it chose wrong index).
> Look into Designing and Tuning for Performance manual for hints.
> Then you can use set autotrace on command in SQL*Plus
> to see execution plan and some other useful info about
> your query execution.
>
> Andrew Velichko
> Brainbench MVP for Oracle Developer 2000
> http://www.brainbench.com
> --------------------------------------------------------------
>
> <terry_stjean_at_my-deja.com> wrote in message
> news:903aki$3ju$1_at_nnrp1.deja.com...
> > I have a view created which joins 3 tables. A product table, a store
> > table and a sales transaction table.
> > Up until this past week, hen I queried the view, the performance wasn't
> > bad, however this week the performance is really slow. This is even
> > with no on else on the system.
> > No changes have been made to the view and no data was added to the 3
> > tables the view uses.
> > I have no idea what is going on. Any ideas of things to check?
> > We are running Oracle 8.0.5 on NT 4.
> >
> > Terry
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Nov 29 2000 - 17:28:17 CST