Re: View performance problem

From: Andrew Velichko <andrew_velichko_at_yahoo.com>
Date: Wed, 29 Nov 2000 17:42:08 -0500
Message-ID: <tDfV5.73734$Z2.999471@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 - 16:42:08 CST