1) Have an index for each field that is part of the filter
2) SET DELE OFF, assuming you don't have any deleted records. If you do have deleted records, change the way you remove records to rename key id's or setting a flag field vs deleting...either that or pack often.
3) Use SELECT *... vs filter
4) Don't have tables index orders set while filter is active.

>Hi -

>ANy suggestions on increasing peformance when applying a filter to a large table. Its seems to be taking forever.
>Unfortunately we can can't put the filter expression into the index.
>
>Any ideas please
>
>Thanks,
>
>Larry