Why is TiDB reverse index 20% slower? Are there any improvement plans?

Translated
1

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

Original topic: TiDB逆序索引，为啥会慢20%？ 有相关改进计划吗？

| username: Atlan

I saw on the official documentation page that reverse indexes are 20% slower and it’s best not to use them. I want to ask why they are so much slower? Are there any plans for improvement?

image
image771×175 4.95 KB

【TiDB Usage Environment】Testing
【TiDB Version】v.5.4.2
【Problem Encountered】Reverse index is 20% slower

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

It doesn’t support reverse indexing, right? I think this is referring to reverse scanning of a sequential index.

3
| username: Atlan | Original post link

Yes, reverse scan of sequential index.

4
| username: cs58_dba | Original post link

Version 6.0 also doesn’t mention any improvements in this regard.

5
| username: Atlan | Original post link

So, is the current support still like this?

6
| username: Billmay表妹 | Original post link

You can submit your product requirements here.

7
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.