Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!wn14feed!wn12feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi_feed4!attbi.com!sccrnsc03.POSTED!not-for-mail From: "Jim Kennedy" Newsgroups: comp.databases.oracle.misc References: <3e6433d0$1@shknews01> Subject: Re: Meaning of Reverse index ? Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: NNTP-Posting-Host: 12.241.221.105 X-Complaints-To: abuse@attbi.com X-Trace: sccrnsc03 1046755243 12.241.221.105 (Tue, 04 Mar 2003 05:20:43 GMT) NNTP-Posting-Date: Tue, 04 Mar 2003 05:20:43 GMT Organization: AT&T Broadband Date: Tue, 04 Mar 2003 05:20:47 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.misc:94323 X-Received-Date: Mon, 03 Mar 2003 22:20:39 MST (news.easynews.com) 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" wrote in message news:3e6433d0$1@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. > >