Re: Do reverse key indexes rebuild themselves???

Yes, the reverse index is automatically maintained like every function based index.

So there is no need to issue an "alter index rebuild...". However, because reverse indexes are treated as function based indexes you cannot do "alter index rebuild ... online". This is a major drawback with large tables.

Martin

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 - 10:32:40 CST