Do reverse key indexes rebuild themselves???

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