1 Reply Latest reply: Jun 24, 2011 2:33 AM by 655560 RSS

    order by case insensitive?

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