Collate

Oracle non-linguistic varchar2 columns to order by without sorting

By Franck Pachot . Sorting data is an expensive operation and many queries declare an ORDER BY. To avoid the sort operation you can build an index as it maintains a sorted structure. This helps with Top-N queries as(…)