>Hi, just jumping in on this.
>
>Problem now is speed. Using the NOFILTER or the INTO TABLE means that the query now takes 90 seconds, instead of 90 milliseconds. I'm trying to retrieve about 400,000 records from a table with 1 million records in it. Surely this should be achievable in a very short time?
>
>Has anyone got any ideas?
>
>René.

Do you have an index set on the table?
Get rid of any Deleted() tags from the index
What's the where clause in your select statement?