📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Guides

Tutorials

Reference

Aggregating Index

This page provides a comprehensive overview of aggregating index operations in TiDB Cloud Lake, 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 TiDB Cloud Lake are used to improve the performance of aggregate queries by pre-computing and storing aggregate results.