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.