From oracle-l-bounce@freelists.org Fri Mar 12 10:25:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CGPwj10194 for ; Fri, 12 Mar 2004 10:25:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2CGPwo10189 for ; Fri, 12 Mar 2004 10:25:58 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60DFF394BCA; Fri, 12 Mar 2004 11:25:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 11:23:40 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from amer-mta01.csc.com (amer-mta01.csc.com [20.137.2.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DFFB7394BB7 for ; Fri, 12 Mar 2004 11:23:33 -0500 (EST) Received: from csc.com (va-fch34.csc.com [20.6.39.227]) by amer-mta01.csc.com (Switch-3.1.2/Switch-3.1.0) with ESMTP id i2CGVXZB003657 for ; Fri, 12 Mar 2004 11:31:33 -0500 (EST) Received: from computer-qd3rtm.yahoo.com ([20.4.114.43]) by csc.com (Lotus Domino Release 6.0.3) with ESMTP id 2004031211302574-10701 ; Fri, 12 Mar 2004 11:30:25 -0500 Message-Id: <5.2.1.1.2.20040312112644.00bc8028@pop.netaddress.com> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Fri, 12 Mar 2004 11:28:36 -0500 To: oracle-l@freelists.org From: Maryann Atkinson Subject: Re: Login Trigger In-Reply-To: <20040312161544.GC2257@mladen.wangtrading.com> References: <4051DF65.5D9D9E@sun.com> <5.2.1.1.2.20040312104106.01ceac38@pop.netaddress.com> <4051DF65.5D9D9E@sun.com> Mime-Version: 1.0 X-MIMETrack: Itemize by SMTP Server on VA-FCH34/SRV/CSC(Release 6.0.3|September 26, 2003) at 03/12/2004 11:30:26 AM, Serialize by Router on VA-FCH34/SRV/CSC(Release 6.0.3|September 26, 2003) at 03/12/2004 11:30:26 AM, Serialize complete at 03/12/2004 11:30:26 AM Content-Type: text/plain; charset="us-ascii"; format=flowed X-archive-position: 692 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: maryann_30@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Thanks for the response ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > It sounds like you want to prerun the user's query. While this is > > possible from a technical point of view, it is not a wise idea. > >Actually, it is. It is called "materialized view" and is done on regular >basis. >If you create it on prebuilt table which is in the "KEEP" pool, you get as >close to pre-caching the results of the desired query as possible. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Now I am lost... can you perhaps provide some steps? Thanks, maa ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------