>>In the case of the returning a large number of index keys, I agree. This is exactly why the last two conditions were slower because they returned nearly the entire table.
>
>I just wanted to make sure to clarify a possible confusion: you have to distinguish between returning a large number of INDEX KEYS and a large number of RECORDS. If you combine two or more conditions, one or more parts of the condition may return a large number of INDEX KEYS, although the final result may return only a few RECORDS. It is here that Full Rushmore Optimization is not always desirable. I will provide further examples if requested.
>
>Hilmar.

I'm interested. Please show me some examples.

Dan