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

Answers embedded.

Hth,

Sybrand Bakker, Senior Oracle DBA

"VWP914" <vwp914_at_aol.com> wrote in message news:20010929163412.08555.00002153_at_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).

Yes
Don't know why you want to have a non-idexed table though, as every table needs Primary KEY

> 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?

of CACHE

Or should I just use KEEP?

in conjunction with KEEP, as not using KEEP will place them on the MRUlist

> But then KEEP seems to stay till instance shutdown.
>
> -Thomas
Received on Sat Sep 29 2001 - 16:01:03 CDT