PolarDB-X CCI — Clustered Columnar Index for OLAP/HTAP

Create and use Clustered Columnar Index (CCI) to accelerate OLAP analytical queries on PolarDB-X 2.0 Enterprise Edition (AUTO mode). CCI provides row-column hybrid storage (HTAP) — OLTP queries use row-store partitioned tables while OLAP queries leverage columnar storage.

Scope: PolarDB-X 2.0 Enterprise Edition + AUTO mode database only.

What is CCI

CCI is a columnar clustered index stored on object storage. It stores all columns from the primary table in columnar format by default, optimized for scan-heavy analytical workloads (aggregation, GROUP BY, wide table scans).

Key characteristics:

• Stores ALL columns (clustered) — no need to specify covering columns.
• Columnar format — optimized for large range scans and aggregations.
• Based on object storage — lower cost than row-store for large data volumes.
• Eventually consistent — writes have some latency (not real-time).
• Online creation — does not block DML on the primary table.

Core Workflow