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