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

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

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

    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 ( to me. Thanks.

    Best regards,
    Rucong Zhao
    Oracle Berkeley DB XML


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