Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can a query reuse data???

Can a query reuse data???

From: Oraboy <oracle_boy99_at_hotmail.com>
Date: 1 Aug 2006 08:45:25 -0700
Message-ID: <1154447125.681628.187820@m79g2000cwm.googlegroups.com>


I understand that data blocks are kept in the buffer cache but can someone clarify the following

If i issue a query thats run before as well as avoiding a parse can Oracle make use of the previous result set or does it always go back and fetch the data from either the buffer cache or disk??

Thanks Received on Tue Aug 01 2006 - 10:45:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US