SORT
Top  Previous  Next

Operating Condition

Syntax: SET SORT ON/OFF

Default: OFF

SET SORT sets the sort optimizer on or off. When set on, R:BASE sorts the minimal amount of data for large tables and recombines the sorted data with the unsorted rows using the minimum amount of disk space. Set SORT on when a sort fails.

SORT is only to be used when displaying a column, or columns, which are not indexed. Otherwise, no results will be displayed.