Re: Right Hand Index
- From: Charles Hart <cchart3@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 2 Oct 2004 02:17:33 -0500
This is a cut from asktom.oracle.com
====================================================
1. 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.
====================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
