Will adding an index to a TiDB field speed up TiFlash query performance?

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

Original topic: 对tidb的字段添加索引后,会加速tiflash的查询速度吗?

| username: TiDBer_rYOSh9JN

Will adding an index to a field in TiDB speed up TiFlash queries?

| username: Kongdom | Original post link

No, TiFlash does not use indexes; it is a columnar storage.

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

No, TiFlash cannot use indexes, it’s similar to a full table scan.

| username: zhanggame1 | Original post link

No, but it is possible that the execution plan chooses to use the index instead of TiFlash.

| username: system | Original post link

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