Re: Index for very small tables needed ?

If you're afraid your table has to be read from disk over and over again, you can do two things:

• specify the CACHE clause for your table. The table blocks will be put at the MRU-side of the LRU-list and so will be east likely candidates for removal.
• as from Oracle 8: specify BUFFER_POOL KEEP for your table which will keep your table blocks in memory.

Jaap.

On Thu, 27 Dec 2001 09:23:19 +0100, Andreas Wizemann <AWizemann_at_fvvag.de> wrote:

>Hi,
>do i need to define an index on small tables ?
>I'm confused after reading different articles about this.
>One tells me i should define an index the other says there is no need,
>as a full table scan is fast enough.
>Also other articles say, oracle does not read rows in the buffer cache
>while doing a Full table scan. So i think, next time this table will
>be accessed there is another need of doing io.
>So now, whats best ?
>No Index with Full table scan and io's
>or
>Having an Index, so rows may stay in buffer ?
>
>Any Ideas ?
>Thanks a lot.
>
>Andreas Wizemann
Received on Sun Dec 30 2001 - 06:38:00 CST