Show/Hide Toolbars


NoteThis command is defined in a header file and will be preprocessed by the X# preprocessor to a function call. If you disable the standard header (-nostddefs) files then this command will not be available. If you tell the compiler to use a different standard header file (-stddef ) then this command may also be not available


Change the setting that determines whether to optimize using the open orders when processing a filtered database file.


SET OPTIMIZE ON | OFF | (<lToggle>)


ONTurns optimization on.


OFFTurns optimization off.


<lToggle>Turns optimization on if TRUE or off is FALSE.
Note:  The initial default of this setting depends on the RDD.  Check RDDInfo(_SET_OPTIMIZE) to find out the setting for the RDD in use for the current work area.


For RDDs that support optimization, such as DBFCDX, SET OPTIMIZE determines whether to optimize filters based on the orders open in the current work area.  If this flag is ON, the RDD will optimize the search for records that meet the filter condition to the fullest extent possible, minimizing the need to read the actual data from the database file.

If this flag is OFF, the RDD will not optimize.



See Also

DbSetFilter(), RDDInfo(), SET FILTER