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 -> Re: What is meant by "full table scan?"

Re: What is meant by "full table scan?"

From: VWP914 <vwp914_at_aol.com>
Date: 29 Sep 2001 20:34:12 GMT
Message-ID: <20010929163412.08555.00002153@mb-md.aol.com> 





So, is it safe to say that any non-indexed table is subject to a full table
scan regardless of what you have for your "where" clause?  (I am using 8i). 
The table in question only ever has a handful of rows - non-indexed, yet is
accessed by every application that we have.  Would that be an application of
NOCACHE - so that those rows stay in the Buffer?  Or should I just use KEEP? 
But then KEEP seems to stay till instance shutdown.



-Thomas
Received on Sat Sep 29 2001 - 15:34:12 CDT












Original text of this message













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