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 -> REPOST: Index for very small tables needed ?

REPOST: Index for very small tables needed ?

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Thu, 27 Dec 2001 09:23:19 +0100
Message-ID: <0$--$$-$$_%-$$__%$@news.noc.cabal.int>


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

This message was cancelled from within Mozilla...not Received on Thu Dec 27 2001 - 02:23:19 CST

Original text of this message

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