tuning of view
Date: Sun, 12 Dec 1999 23:23:34 GMT
Message-ID: <W7W44.417$5m6.1653855_at_nnrp3.proxad.net>
Hello
[Quoted] [Quoted] 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 - 00:23:34 CET