SET RUSHMORE
Contents
Purpose
Enable or disable Rushmore-style index scanning optimization
Syntax
SET RUSHMORE ON | OFF | (<expL>)
See Also
APPEND BLANK, APPEND FROM, CLEAR PROFILE, COUNT, DISPLAY PROFILE, DO, GENERATE, INDEX, Lianja Operators, LIST PROFILE, LOWER(), PACK, PROFILE, REINDEX, SET COMPILE, SET DCACHE, SET FILTER, SET ICACHE, SET IOLOGGING, SET IOSTATS, SET PERFMETER, SET ROWFILTER, SET STRCOMPARE, SQL DELETE, SQL INSERT, SQL Operators, SQL SELECT, SQL UPDATE, UPPER()
Description
The SET RUSHMORE command enables or disables Rushmore-style (Visual FoxPro) index scanning optimization for NoSQL and SQL commands. SET RUSHMORE is ON by default.
With SET RUSHMORE ON, the speed of the following NoSQL commands is increased by optimizing the FOR condition, active FILTER condition or active ROWFILTER condition.
Indexes should be created on the fields specified in the condition to enable the optimization. For optimum performance, use filtered indexes:
INDEX ON <exp> FOR <condition>
Use of the UPPER() and/or LOWER() functions is not required: with SET STRCOMPARE ON (default), indexes and comparison operators are case insensitive.
NoSQL Command |
---|
AVERAGE |
BLANK |
CALCULATE |
COPY |
COUNT |
DELETE |
LIST |
LOCATE...CONTINUE |
RECALL |
REPLACE |
SCAN...ENDSCAN |
SUM |
TOTAL |
With SET RUSHMORE ON, there is also a major performance boost for very large tables when issuing SQL queries using the >, >=, < and <= operators.
The = and == operators are always optimized.
Example
set rushmore on