In addition to other's good advice - you can "SET EXACT OFF" and index search on a partial key.
>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.
Imagination is more important than knowledge