Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

SORT

Scroll Prev Top Next More

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.