>>Rushmore optimizes an INDEX ... FOR lExpression command if lExpression is an optimizable expression. For best performance, use an optimizable expression in the FOR clause.
>
>Jess, this means that the expression in the FOR clause has to itself be optimizable. That means there must be another index on that expression.
So it clearly explains that an INDEX...FOR (Filtered Index) can be optimizable if the expression is optimizable.
But, if have this set of commands:
SELECT y
SET ORDER TO code (INDEX ON code TAG code FOR code = 'I' - an optimizable index)
CALCU SUM blah..blah.. && not optimizable anymore
SCAN FOR.... && not optimizable anymore
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."