Aggregating Index

This page provides a comprehensive overview of aggregating index operations in Databend, organized by functionality for easy reference.

Aggregating Index Management

Command	Description
CREATE AGGREGATING INDEX	Creates a new aggregating index for a table
DROP AGGREGATING INDEX	Removes an aggregating index
REFRESH AGGREGATING INDEX	Updates an aggregating index with the latest data

note

Aggregating indexes in Databend are used to improve the performance of aggregate queries by pre-computing and storing aggregate results.

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.