Re: tuning of view

I had the same dilemma 2 years ago. I read everything by Oracle with no help. Then I picked up an O'Reilly Performance tuning book that so plainly said something like "Never join a view to a view as it most often confuses the Optimizer." I guess Oracle didn't want to point that out. I had to re-approach my process and solved it with a table that builds hourly that is well indexed as that is how users worldwide queried my DB and the view to view was worse than unacceptable. rq

PERPEN Manuel wrote:

> Hello
>
> I'm working with Oracle and i have a big problem with a request with wiews.
> I have to use a request composed of 3 views. I have to wait 8 hours to have
> the result but i need less than 6 minutes to have the result of every of the
> view with a separate treatment. When i use the result of every view in
> access i need 3 seconds to have the final result.
>
> View1 : 2500 lines in 2 minutes
> View2 : 4000 lines in 4 minutes
> View3: 2000 lines in 2 minutes
> The final request composed of view1 ,view2 and view3 : 8 hours
> The results of view1, view2 and View3 in ACCESS : 3 seconds.
>
> I think that it's not possible for access to be faster than oracle!! If you
> have an idea i thank you very much to send me an email at
> manuel.perpen_at_free.fr
Received on Mon Dec 13 1999 - 16:31:22 CET