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



Oracle LazyDBA home page