Related Concepts
- Index columns: When creating an index, you can specify some columns of the data table as index columns. Those columns are used as part of the primary key of the index table to accelerate queries.
- Covering columns: When creating an index, you can specify some columns of the data table as covering columns. Those columns are redundantly stored in the index table to accelerate the query of non-index columns without querying the data table.
- Composite indexes: Multiple columns can be specified as index columns (cross-column family is supported).
- Covering indexes: Multiple columns can be specified as covering columns and are redundantly stored in the index table. Those columns are used to accelerate the query of non-index columns.
Parent topic: Feature Overview