Operating Condition
Syntax: SET INDEXONLY ON/OFF
Default: ON
Sets a flag to disable "index only" data retrievals.
When INDEXONLY is ON, R:BASE is enabled to retrieve data using only data from the index or key structures and not the actual table rows. This is the default behavior.
If INDEXONLY is set to OFF, R:BASE must retrieve data from the actual rows of the tables. R:BASE will still use an index to speed finding rows if possible, but actual data must come from the rows and not the index. This is sometimes required when multi-column indexes are used, and not all columns in the index are used in the WHERE clause.
