Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index for very small tables needed ?
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