>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, I'm going to make this test, but thought, somebody already has an answer.
>>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.
If it's not broken, fix it until it is.
My Blog