>There are times where you should not use NOFILTER due to performance hits.
>For example, if your SQL statement doesn't have a WHERE clause, don't use
>NOFILTER, if it does have a WHERE clause, use NOFILTER unless you need to subquery it. IF you have a parameterized query, then you should use NOFILTER.
>
>Did you catch all that? :)
Yes, I'm an original veteran of NOFILTER, been using it since early vfp5 :) I need it virtually everywhere in my simple SQLs. Haven't noticed any performance problems using it on large tables, as long as Rushmore is in effect at least partially. Though our machines, servers, and lines are so fast now that maybe it's not surprising...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.