This is a cut from asktom.oracle.com
- Can you elaborate on 'right-hand index problem'? What is it? How to
detect it and how to avoid it?
Tom wrote
1) it is a rare issue in very high end systems. It is inserting into a table
that has an index on a column that is always increasing (eg: a column
populated by a sequence). All of the values goto the "right hand
side".
reverse key indexes may be useful in such a case. It is *very rare*
to need to go that far.
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 02 2004 - 02:13:08 CDT
