Aggregate functions

An aggregate function that receives arguments that are all literals in a query with no user tables runs on the host. A grand aggregate with normal tables runs on both host and SPU. A grouped aggregate with normal tables runs on both host and SPUs or only on the SPUs. A windowed aggregate with no partition clause runs on the host; in all other cases, it runs on the SPUs.