Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

MANOPT

Scroll Prev Top Next More

Operating Condition

 

Syntax: SET MANOPT ON/OFF

 

Default: OFF

 

MANOPT set to OFF disables the automatic table-order optimization that R:BASE performs when running queries. This gives maximum control over the order in which columns and tables are assembled in response to a query.

 

With MANOPT set to ON, R:BASE uses the order of the tables in the FROM clause and the order of the columns in the column list of the SELECT clause to construct the query.

 

When MANOPT is set on, the #TABLEORDER system variable stores the table join order, and the applicable indexed columns. To display the table order, use the following:

 

PAUSE 2 USING .#TABLEORDER

 

 

See Environment Optimization