Thanks for the clarification.
>It all depends on having Rushmore optimizable indexes and how far away the first filtered record is from the top of the file in the current SET ORDER. Without Rushmore optimization, there is no difference. With optimization there can be a big difference. I have a table with a million records. Each record has a "primary key" (SPD_ID) that corresponds to the record number.
>...
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)
