Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can a query reuse data???
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