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.
-----------------------------------------------------------------


Oracle LazyDBA home page