Re: Indexes on very small tables

From: Michael Zhang <zhangliuqing_at_hotmail.com>
Date: Thu, 8 Jul 1999 20:22:38 -0400
Message-ID: <ihbh3.161$Ay3.196478976@momma.bigmomma.com>

Hi:

The way Oracle use index is like this:
1 read index block
2 if data entry is found in the index block, read data block. So, if the data of your table is larger than 2 blocks, it's useful to use index, for 1 and 2 blocks tables, indexes are not necessary.

Michael.

Jantah <jantah_at_big.hand.com> wrote in message news:37880af4.2058374_at_news.a2000.nl...
> 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 Thu Jul 08 1999 - 19:22:38 CDT