I am looking for some tips and tricks to make our aggregation flows run quicker. The target table is an aggregation of our products from the invoice level by product.

one strategy we had was trying to use cache:
ENGINE INT CACHE SET ON
ENGINE INT CACHE STAT

We have placed this before our aggregation but when the flow runs, the log shows this:
DEP_4: procedure cache_on started.
: no CACHE entries
DEP_4 cache_on Return Code = 0

This of course is just one of the strategies. We understand that this is a huge aggregation. We are working on the aggregation process on our sql server but we are looking for any advice to make aggregations quicker

This message has been edited. Last edited by: Tamra,

The CACHE setting does speed up certain processing but it's primarily for use with DB_LOOKUP. Otherwise it won't help.

Assuming your source is in a relational database and that by aggregation you mean use of GROUP BY ensure that the query is passed through to the RDBMS.

Thanks Cliff.

Yes, you assumed correctly that our source is a relational database and the aggregation is built from group by.