Managing Aggregates

The Managing Aggregates is a feature in Space Management that improves query performance by creating pre-aggregated tables at higher levels of granularity, reducing runtime processing.

On this page you can perform these actions:

  • Create Aggregates

    Specify logical queries to create aggregate tables that support faster reporting.

  • Compression & Pre-Join

    Aggregates compress data and pre-join large tables to optimize performance.

  • Incremental & Full Refresh

    Choose incremental updates or full rebuilds for aggregate tables.

  • Enable/Disable Aggregates

    Control aggregate usage during testing and performance tuning.

Note: 

Use aggregates for large data sets to reduce query time.

Validate logical queries and avoid duplicate column names.

Apply incremental filters for efficient updates.