Hi Franco,
if you want to use the $ operator, there is no way to optimize your filter. Try with three index tags, one for Department, one for Section, and one for Unit. Then you can use
SET FILTER TO Department=cDept and Section=cSect and Unit=cUnit which will be optimized.
>Hi
>
>I am doing a SET KEY on a table and then I need to run a filter on the records :
>
>SET FILTER TO "[" + Department + Section + Unit + "]" $ cDepSecUnit)
>
>where cDepSecUnit is a list of Department+Section+Unit contained in []. Eg: [Dep1Sec1Unit1][Dep2Sec2Unit2]...
>
>For this filter to be optimised, do I need an index on each of Department, Section, and Unit individually, or do I need one index with all three fields?
>
>Any help would be appreciated. Thanks.