Does TiFlash support secondary indexes?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tiflash 支持二级索引吗?

| username: TiDBer_TkoMdI15

Currently, I have only found information about secondary indexes existing in TiKV, but not in TiFlash.

If TiFlash supports secondary indexes, what performance issues might arise?

| username: Billmay表妹 | Original post link

Refer to:
The data in TiFlash is mainly divided into two parts: Delta and Stable. The Stable data is organized by Packs, with each Pack containing approximately 8192 rows. To ensure the correctness of secondary indexes, data with the same primary key needs to be written into the same Pack during insertion. This ensures the correctness of MVCC when filtering with secondary indexes. For a more detailed explanation, you can look forward to the subsequent source code analysis of the DeltaIndex topic.

[Event Video Replay]:
[PPT Download]: TiFlash Storage Layer Overview.pdf (877.2 KB)

| username: 啦啦啦啦啦 | Original post link

Not supported, this issue was also discussed a few days ago, refer to this link

| username: 特雷西-迈克-格雷迪 | Original post link

TiFlash does not currently support traditional indexes, rough indexes.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.