Please show me a few different SET FILTER expression that you use today, and which you want to run faster, then it's easier for me do give a good answer.
And by the way, do you need to set filter? What about a cursor selected from your table?
>Hi Tore.
>
>Sorry for the delay in answering.
>
>The problem is that if I do not use $ and filter on Department+Section+Unit, I will end up with a huge filter string. I can't build up the filter for department, section, and unit individually.
>
>If i have the three individual indexes and then do the filter as it was originally (Department+Section+Unit $ cDepSecUnit), it still won't be good ?
>
>
>Thanks