The default sorting using orderBy clause is case sensitive, means, it first sorts the Words starting with CapitalCase and then sorts lower case (order by <Column_Name> ASC) . Is there a way to make it case insensitive like we have in other SQL database. For now , i have used something like : order by lower( <Column_Name> ) DESC . Is this a right way to do as I see some performance impact if number of records is large ?