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.