Revese Key Index

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: Mon, 03 Jan 2000 20:20:41 GMT
Message-ID: <387104D4.B16FB6FE@cc.gatech.edu>

If someone is using an auto increment primary key, is it a good idea to create a reverse index on this column?

Are there any disadvantages to creating a reverse index? What if a DBA just rebuilds a normal index periodically. Would that take away the advantage of a reverse key index?

Thanks.

Paul

John Shaft wrote:

> Hi,
>
> Does Oracle has a way to define a table such that the primary key gets
> auto-incremented with each new insertion? If not, how do you keep your
> primary keys unique? (With a store value read and incremented in a
> transaction?)
>
> I have a databse devloped orignally for MySQL and want to port it to
> Oracle 8. I wondered about this issue.
>
> Thanks!
>
> shaft_at_meanmutha.com
> http://www.meanmutha.com
Received on Mon Jan 03 2000 - 14:20:41 CST