|Oracle9i Database Reference
Release 1 (9.0.1)
Part Number A90190-02
Initialization Parameters, 123 of 220
|Range of values||
NLS_SORT specifies the collating sequence for
ORDER BY queries.
BINARY, then the collating sequence for
ORDER BYqueries is based on the numeric value of characters (a binary sort that requires less system overhead).
NLS_LANGUAGEparameter also support a linguistic sort with the same name.
NLS_SORT to anything other than
BINARY causes a sort to use a full table scan, regardless of the path chosen by the optimizer.
BINARY is the exception because indexes are built according to a binary order of keys. Thus the optimizer can use an index to satisfy the
ORDER BY clause when
NLS_SORT is set to
NLS_SORT is set to any linguistic sort, the optimizer must include a full table scan and a full sort in the execution plan.
You must use the
NLS_SORT operator with comparison operations if you want the linguistic sort behavior.