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!

descending index question

AlleTFeb 10 2012 — edited Feb 10 2012

Why do we have to create descending index for ORDER BY ... DESC clauses?

Couldn't Oracle just scan an ascending index in the opposite way, I mean scanning it from the highest value to the lowest ?

This post has been answered by Jonathan Lewis on Feb 10 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2012

Added on Feb 10 2012

#general-database-discussions

4 comments

317 views