>But if you set EB to 70, will this:
>
>Select UserID, MemberName, Count(*) as NTally Group by UserID
>
>...typically run faster than this:
>
>Select UserID, MemberName, Count(*) as NTally Group by UserID, MemberName
>
>????

I don't know I never timed it. Setting EB to 70 to me is like saying set SQL to not compliant with the standard and I don't like it. It is a last resort for running old code in VFP9 without making major modifications to the code itself. Writing new code should follow the ANSI SQL Standard and it should not have any problem with the group by rules.