>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.
Erik Moore
Clientelligence
