Re: tuning of view

Please post your view definitions and the queries you use to display the contents of the three views. That way somebody might be able to try and help.

Regards,

Jon.

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 - 11:47:48 CET