solidDB Help : solidDB reference : SQL: Statements : Hints : EXTERNAL SORT
  
EXTERNAL SORT
The EXTERNAL SORT hint specifies that the query executor use the external sorter. Use this hint when the expected result set is large and does not fit in memory; for example, if the expected result set has thousands of rows.
Example:
SELECT
--(* vendor(SOLID), product(Engine), option(hint)
-- EXTERNAL SORT *)--
* FROM TAB1 ORDER BY 1
Go up to
Hints