Re: Indexes on very small tables

You need to do tests with and without an index. In some cases performance will actually decrease with an index. On the other hand you may need the index to enforce a Unique constraint. Conventional wisdom is that tables with a trivial rowcount should not have indexes and should also be static tables (i.e. they should not have inserts/updates as part of normal processing - in other words, if they have a small row count then they are probably look-up/reference tables).

Ken

Jantah wrote:

> Quick question:
>
> Will an index improve performance if the indexed table fits in one
> Oracle block?
> --
> Jan
> jantah_at_big.hand.com
> (replace big.hand with bigfoot to email Jan)
Received on Fri Jul 09 1999 - 06:59:01 CDT