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

reverse bytes of each column : cba 321
keeping the column order intacted: cba321

cba321 should be the ordering

test it with both column indexed with reverse keyword and you will see it
from the dump





"Qi cheng "
<oracledba-ezmlms
hield-x48193168.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
08/29/2006 02:08
PM 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