📣New in Public Preview: TiDB Cloud BYOC, TiDB Cloud Filesystem, PostgreSQL-compatible TiDB Cloud Starter

Sign In Start for Free

TiDB Cloud Lake

Get Started

Guides

Connect
Manage Resources
Data Integration
Load Data
Unload Data
Multimodal Data Analytics
Performance Tuning
Security & Reliability
Management

Pricing & Billing

Troubleshooting

Tutorials

Ingest & Stream Data
Migrate Data

Reference

SQL Reference
General Reference

Support Services

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

Aggregating Index

Note

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

Was this page helpful?