Re: Do reverse key indexes rebuild themselves???

uh - "patch to the current release ..."

I'd apply the 8.1.6.3.0 and 8.1.6.3.4 patch sets. (with proper backups before and after)

Paul

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 Sun Apr 01 2001 - 23:36:06 CDT