>>Nadya
>>
>>Why don't you just try it on a small table and find out? Its very easy to build a couple of indexes. FWIW, I suspect a filtered index would be smaller, but I haven't checked.
>

Yes, the filter causes the record not to be contained in the index. Thus, in the 500,000 record table and a filter applying to only one, will add only that one record to the index (CDX file).

>Yes, I'm going to make this test, but thought, somebody already has an answer.

BTW, how is your footer-text to be interpreted ? ;))