Xref: alice comp.databases.oracle.misc:49119 Path: alice!news-feed.fnsi.net!netnews.com!isdnet!proxad.net!feeder2.proxad.net!nnrp3.proxad.net.POSTED!not-for-mail From: "PERPEN Manuel" Newsgroups: comp.databases.oracle.misc Subject: tuning of views Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Message-ID: <3_V44.415$nu6.1819756@nnrp3.proxad.net> Date: Sun, 12 Dec 1999 23:13:03 GMT X-Complaints-To: abuse@proxad.net X-Trace: nnrp3.proxad.net 945040383 213.228.23.173 (Mon, 13 Dec 1999 00:13:03 MET) NNTP-Posting-Date: Mon, 13 Dec 1999 00:13:03 MET Organization: Guest of ProXad - France 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@free.fr