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

Index for very small tables needed ?

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Thu, 27 Dec 2001 09:23:19 +0100
Message-ID: <haml2ukh1eere5p9mcrp3k8jule26k6hn2@4ax.com>


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 Thu Dec 27 2001 - 02:23:19 CST

Original text of this message

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