Reference Guide > TDV Query Engine Options > SELECT Options > DISABLE_SORT_REMOVAL (SELECT Option)
 
DISABLE_SORT_REMOVAL (SELECT Option)
DISABLE_SORT_REMOVAL causes the SELECT to retain the ORDER BY clause in the sub-query.
Operator
SELECT
Syntax
disable_sort_removal
Example
SELECT {OPTION DISABLE_SORT_REMOVAL}