The Meaning of Auto-Increment Index

Translated
1

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

Original topic: 自增索引含义

| username: HACK

【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】
【Encountered Problem】

What is an auto-increment index? Is it the index corresponding to the auto-increment primary key? Or is it the index on the auto-increment column?

【Reproduction Path】What operations were performed to encounter the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: h5n1 | Original post link

Index on auto-increment column

3
| username: HACK | Original post link

I saw some technical points saying that auto-increment indexes cannot be created, but I tested it and it can be created.

4
| username: wuxiangdong | Original post link

An index must be added to the auto-increment column.

5
| username: system | Original post link

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