Dear Stephen,

If you are crating the reverse index... avoid to perform range scan.

In my opinion, it reverse the entire string wether it is a number or varchar.

e.g:= abc123 gives you 321cba



Thanks & Regards,
Rajesh Kumar Mathur
Tech Mahindra Ltd.
Sharda Center.
Erandwane. Pune - 04
Mob:- 9860564121


Quoting Hans <oracledba-ezmlmshield-x1752719.[Email address protected]

>
> Creating a reverse key index, compared to a standard index, reverses the
> bytes of each column indexed (except the rowid) while keeping the column
> order.
>
>
> I think it will be cba321
>
> Hans
>
> -----Original Message-----
> From: Weston Stephen
> [mailto:oracledba-ezmlmshield-x23336752.[Email address protected]
> Sent: woensdag 30 augustus 2006 9:54
> To: LazyDBA Discussion
> Subject: RE: reverse index
>
>
> The 'reverse' key will be abc123.
>
> The meaning of reverse key is the same as order by xxx desc. In other
> words it will be in highest to lowest sort order,
>
> Stephen
>
> -----Original Message-----
> From: Qi cheng
> [mailto:oracledba-ezmlmshield-x48193168.[Email address protected]
> Sent: 29 August 2006 22:08
> To: LazyDBA Discussion
> Subject: reverse index
>
> if a reverse index key has more than one column, will reverse index
> reverse the first column or the concat columns?
>
> let's say, column1 is 'abc' column2 is '123', the reverse key will be
> cba123 or 321abc, or 321cba?
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> -----------------------------------------------------------------
> ATTENTION:
> The information in this electronic mail message is private and
> confidential, and only intended for the addressee. Should you
> receive this message by mistake, you are hereby notified that
> any disclosure, reproduction, distribution or use of this
> message is strictly prohibited. Please inform the sender by
> reply transmission and delete the message without copying or
> opening it.
>
> Messages and attachments are scanned for all viruses known.
> If this message contains password-protected attachments, the
> files have NOT been scanned for viruses by the ING mail domain.
> Always scan attachments before opening them.
> -----------------------------------------------------------------
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>



============================================================================================================================

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page