Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse key Indexes Oracle 8.0

Re: Reverse key Indexes Oracle 8.0

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Mon, 29 Nov 1999 16:42:48 GMT
Message-ID: <3842ac32.11741392@read.news.globalnet.co.uk> 





On 29 Nov 1999 12:46:39 +0000, Robin Smith
<smithrc_at_zdbaora.nat.bt.com> wrote:



>records will always be added to the right hand side of the index so it


>will become skewed. If you reverse the key then entries will also go


>into the middle of the index so will become self balancing.





A b*tree index cannot become skewed.
Received on Mon Nov 29 1999 - 10:42:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US