Re: Index performance
From: Bruce Pihlamae <bpihlama_at_nla.gov.au>
Date: 1996/08/19
Message-ID: <32189E6E.51E0_at_nla.gov.au>#1/1
Date: 1996/08/19
Message-ID: <32189E6E.51E0_at_nla.gov.au>#1/1
Joel Garry wrote:
...snip...
> To be a little more responsive, Oracle keeps indices as balanced b-trees,
> so some shuffling may need to take place to keep the balance, trading
> off slowness at add/insert for predictibility/speed at select. See
> the Oracle Concepts manual for a more in depth explanation, and you
> may want to run some tuning on your indices.
Oracle indexes are only partially balanced.
After a lot of insert or delete activity the index will become inefficient with lots of wasted space. This is why it is recommended to rebuild such indexes on a regular basis and why Oracle have added a new command in 7.3 to rebuild an index in place.
Bruce... Received on Mon Aug 19 1996 - 00:00:00 CEST