Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create index in ASC or DESC order

626620Jan 28 2010 — edited Jan 30 2010
I recently learnt that create index idx on eprson(name desc) will create a function based index. I think a DESC index can be used in ORDER BY DESC. I am wondering what other use can a DESC index be?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2010
Added on Jan 28 2010
4 comments
16,184 views