Faster to use "Group" or "First"?

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
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?
 
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.
 
Back
Top