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?
Thanks [sig][/sig]
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?
Thanks [sig][/sig]