Performance Optimization TiDB Cloud Lake primarily accelerates query performance through various indexing technologies , including data clustering, result caching, and specialized indexes, helping you significantly improve query response times.
Optimization Features Feature Purpose When to Use Cluster Key Automatically organize data physically for optimal query performance When you have large tables with frequent filtering on specific columns, especially time-series or categorical data Query Result Cache Automatically store and reuse results of identical queries When your applications run the same analytical queries repeatedly, such as in dashboards or scheduled reports Virtual Column Automatically accelerate access to fields within JSON/VARIANT data When you frequently query specific paths within semi-structured data and need sub-second response times Aggregating Index Precompute and store common aggregation results When your analytical workloads frequently run SUM, COUNT, AVG queries on large datasets Full-Text Index Enable lightning-fast semantic text search capabilities When you need advanced text search functionality like relevance scoring and fuzzy matching Ngram Index Accelerate pattern matching with wildcards When your queries use LIKE operators with wildcards (especially '%keyword%') on large text columns
Feature Availability Feature Community Enterprise Cloud Cluster Key ✅ ✅ ✅ Query Result Cache ✅ ✅ ✅ Virtual Column ❌ ✅ ✅ Aggregating Index ✅ ✅ ✅ Full-Text Index ✅ ✅ ✅ Ngram Index ✅ ✅ ✅