Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse key Indexes Oracle 8.0
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