Add a pre-aggregation
In this step, we'll add a pre-aggregation to optimize the performance of a specific query. Pre-aggregations are a caching technique that massively reduces query time from seconds to milliseconds. They are extremely useful for speeding up queries that are run frequently.
From thetab, execute a query:
Just above the results, click onto bring up the Rollup Designer:
The Rollup Designer will automatically suggest a pre-aggregation for the query; clickand then retry the query in the Playground. This time, the query should be accelerated with a pre-aggregation:
And with that, we conclude our Getting Started with Cube guide. If you'd like to learn more about Cube, check out this page.
Did you find this page useful?