I have several large tables in an Oracle 8 database with primary keys that are sequence numbers. Has anyone ever created a primary key constraint forcing the index to be a reverse key index to eliminate "sliding indexes" (ie. old keys always deleted from one end of the b-tree and always added to the other)?
Also, would a reverse key index be less effecient than a regular index when using the indexed column in a BETWEEN comparison in the WHERE clause of a SELECT statement?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.