+---------------------------------+
|          SET OPTIMIZE           |
+---------------------------------+
SET OPTIMIZE ON | OFF

-----------------------------------
Enables or disables Rushmore.
Default value - ON
-----------------------------------

Database commands that support a FOR clause (and are affected by SET
FILTER) use Rushmore to enhance their performance.  There are rare cases
when you should disable Rushmore.

Rushmore may be globally disabled (or enabled) for all commands that
benefit from Rushmore with SET OPTIMIZE.  Issuing SET OPTIMIZE OFF
disables Rushmore, SET OPTIMIZE ON enables Rushmore.   Every command
that uses Rushmore has a NOOPTIMIZE clause that can be included to
disable Rushmore for the scope of the command.

Here is a table of commands whose performance is optimized by Rushmore
when the FOR clause is included.  SET OPTIMIZE affects each of these
commands.  Each command also supports the NOOPTIMIZE keyword to disable
Rushmore for that command.

AVERAGE                 DISPLAY         REPLACE
BROWSE                  EDIT            REPORT
CALCULATE               EXPORT          SCAN
CHANGE                  JOIN            SORT
COPY TO                 LABEL           SUM
COPY TO ARRAY   LIST            TOTAL
COUNT                   LOCATE
DELETE                  RECALL

-----------------------------------

See Also:  INDEX, SET ORDER

-----------------------------------