Re: Reverse order indexes in Oracle8

From: <dejanews_at_datagen.com>
Date: Fri, 07 May 1999 20:14:11 GMT
Message-ID: <7gvhie$smg$1@nnrp1.deja.com>

Does anybody know exactly how the reversing of values is handled? For example, integers 1 and 10, when reversed, become 1 and 01 - the same numbers (which is not good :) ). I am sure that's not the case in reality. But I do wonder how this reversing is done.

Sergey

In article <7eiskd$p9l$1_at_nnrp1.dejanews.com>, dejanews_at_datagen.com wrote:
> Hello everyone!
>
> Here is an excerpt from an Oracle8 DBA Handbook by Kevin Loney
> (published by Osborne/McGraw Hill):
>
> "... you can create indexes that reverse the order of the data prior to
> storing it. That is, an entry whose data value is '1002' will be indexed as
> '2001'. The reversing of the data prior to indexing helps keep the data
> sorted better within the index. ..."
>
> Does anyone know why reversing of the data helps keep that data sorted better?
>
> Thank you in advance.
> Sergey Serebryakov
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 15:14:11 CDT