Hi John,
I booted into Windows to take a look at the help on index command to see what all is available. This is from the help:
INDEX ON eExpression TO IDXFileName | TAG TagName
[ COLLATE cCollateSequence ] [OF CDXFileName] [FOR lExpression]
[COMPACT] [ASCENDING | DESCENDING] [UNIQUE | CANDIDATE] [ADDITIVE]
You can limit an index file to included pointers only to records that meet a [FOR Expression]. Here what is said about the [FOR Expression]:
FOR lExpression
Specifies a condition whereby only records that satisfy the filter expression lExpression are available for display and access; index keys are created in the index file for just those records matching the filter expression.
Rushmore optimizes an INDEX ... FOR lExpression command if lExpression is an optimizable expression. For best performance, use an optimizable expression in the FOR clause.
For more information, see SET OPTIMIZE and Using Rushmore Query Optimization to Speed Data Access.
Regards,
LelandJ