Improving Performance When Building Aggregate Views on Aggregate Storage Databases

You might encounter the following message while building aggregate views on an aggregate storage database:

For better performance, increase the size of aggregate storage cache

This message sometimes occurs when an aggregate storage database is larger than a few hundred million input cells.

To improve the performance of building aggregates, increase the size of the aggregate storage cache to at least 512 MB or 20% of the input data size, whichever is smaller. Use the MaxL statement alter application with set cache_size grammar.