>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
