Larry,
I think the answer to your question lies in the answer to this question:
Are you trying to filter out a large number of records relative to the total number of records in the table?
The reason that question is important is that filters work very well when you are attempting to remove a few records from a result, whereas a SQL Select statement works better when attempting to select on small subset of information.
HTH,
Travis
>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
Travis Vandersypen