Faster to use "Group" or "First"?

J

Jim Pockmire

I have a query that groups/totals that is linked to another table at the
"group" level. When bringing in fields from the linked table, I can either
specify "Group" or "First" (It doesn't affect the value). Which way will run
faster?
 
V

Van T. Dinh

In my experience, "Group By" seems to be faster than "First" contrary to my
thought that since "First" only picks the first value so it should be
faster.

Since the QBE defaults to "Group By", I usually leave it as "Group By"
unless I need another Total function, anyway.
 
Top