Re: Do reverse key indexes rebuild themselves???

To answer the first question NO.

Second, the advantage is to help avoid buffer busy waits.

alistair.thomson_at_sphinxcst.co.uk wrote:

> Hi
>
> Environment:
>
> Oracle 8.1.6.0.0 on NT4
>
> I've been asked a question regarding reverse key indexes. Specifically, does a
> reverse key index perform an automatic index rebuild after a certain number
> of entries are made to the index?
>
> My initial reaction was no it doesn't.
>
> Also what benefits does a reverse key index bring over a normal btree index
> when the column indexed is a primary key field using a sequence to generate
> the primary key.
>
> Any advice greatly appreciated.
>
> Alistair Thomson
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Thu Mar 29 2001 - 11:27:18 CST