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.

>Hi everybody,
>
>I wrote a message few minutes ago, but I guess, I forgot to send it. Ok, I repeat. I have field APNed (Char 1) and APN (Char 43). I want to create an index APNed+APN for !inlist(APNed,'C',' '). APNed could be D duplicate, S - suspect, B - bad, E - edited. Most common case is "C" - completed or empty - calculation not yet performed. So, my question is: would filter make this index to be more compact?
>
>Thanks in advance.