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.
Regards