This discussion is archived
1 Reply Latest reply: Jun 24, 2011 12:33 AM by 655560 RSS

order by case insensitive?

761557 Newbie
Currently Being Moderated
Hello,

What's the best (optimized) way of sorting case insensitive? Will order by lowercase(field) use an index?

Thanks.
  • 1. Re: order by case insensitive?
    655560 Journeyer
    Currently Being Moderated
    Hi,

    Using lower-case() is a good choice. Whether index takes effect is due to both container indexes and query expression. If you encounter any specified performance issue please post the question or send email (rucong.zhao@oracle.com) to me. Thanks.

    Best regards,
    Rucong Zhao
    Oracle Berkeley DB XML

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points