C5_SET OPTIMIZE

SET OPTIMIZE
 Change the setting that determines whether to optimize using the open orders
 when processing a filtered database file
------------------------------------------------------------------------------
 Syntax

     SET OPTIMIZE ON | OFF | (<lToggle>)

 Arguments

     ON enables optimization.

     OFF disables optimization.

     <lToggle> is a logical expression that must be enclosed in
     parentheses.  A value of true (.T.) is the same as ON, and a value of
     false (.F.) is the same as OFF.

     Note:  The initial default of this setting depends on the RDD.

 Description

     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.

 Examples

     .  The following example enables optimization for the Inventor
        database file using the SET OPTIMIZE command:

        USE Inventor NEW VIA "DBFCDX"
        SET OPTIMIZE ON

 Files   Library is CLIPPER.LIB.

See Also: DBSETFILTER() SET FILTER



Advertisements

One response to “C5_SET OPTIMIZE

  1. Pingback: C5 Commands | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.