Re: Meaning of Reverse index ?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 04 Mar 2003 00:44:08 -0800
Message-ID: <3E646758.A03100F8@exesolutions.com>

Ginger Mall wrote:

> If the index start from 1-10000, then the reverse key will still be 1-10000
> ?
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message
> news:LIW8a.302049$SD6.16384_at_sccrnsc03...
> > It would help spread the index out and not have hot blocks. eg instead of
> > indexing
> > 10001, 10002, 10003,...
> > it would be
> > 10001, 20001, 30001,...
> > Hence there would not be hot blocks if a lot of inserts were happening in
> a
> > short time.
> > Jim
> > "Ginger Mall" <bocgco_at_hongkong.com> wrote in message
> > news:3e6433d0$1_at_shknews01...
> > > I have read from books talking about "reverse index". I know it
> reverses
> > > the order of the key value. However I am not quite understand why this
> > kind
> > > of arrangement could help the B-Tree index to be more efficient. Could
> > > anyone explain this to me ?
> > >
> > > Thank you very much.
> > >
> > >
> >
> >

1, 2, 3, 4 Ok.
But how about 1001, 1002, 1003, 1004?

Surely you don't think we have had an index type, used by many, and included in multiple versions, that doesn't work.

Daniel Morgan Received on Tue Mar 04 2003 - 02:44:08 CST