Strongly recommend completing the global secondary index as soon as possible. If you have any requirements, please comment!

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

Original topic: 强烈建议尽快完成全局二级索引,有需求的请盖楼!

| username: h5n1

Strongly recommend GA for global secondary indexes. I conducted a sysbench test with 256 concurrent connections on a single table (the same set of data replicated 3 times), and the efficiency difference between regular tables and partitioned tables is significant.

25e32bf184fbd3b5e2881d51d0a3cb6

| username: redgame | Original post link

I can do it. Highlight professionalism.

| username: chenhanneu | Original post link

TiDB supports complete secondary indexes, and they are global indexes, which can optimize many queries through indexes. Proper use of secondary indexes is very important for business, and many experiences from MySQL are still applicable in TiDB. However, TiDB also has some unique characteristics that need attention. This section mainly discusses some considerations for using secondary indexes in TiDB.
TiDB Best Practices | PingCAP Documentation Center

| username: 人如其名 | Original post link

Strongly agree!

| username: Kongdom | Original post link

+1

| username: dba-kit | Original post link

The original poster is referring to the global secondary index of partitioned tables, which can significantly speed up queries that “cannot use the partition key but can hit the regular secondary index.” Otherwise, such queries would have to scan the secondary index of all partitions each time, resulting in a significant performance loss.

| username: 有猫万事足 | Original post link

Reasonable and well-founded :+1:

| username: cassblanca | Original post link

Secondary indexes refer to the performance-exploding ClickHouse from the battle-hardened nation MergeTree | ClickHouse Docs. Bloom filters can filter out data that definitely does not exist, but when the distinct value count of the prefix column is very large, the “skipping” acceleration effect on subsequent columns’ filter conditions becomes very weak. Other acceleration optimization query methods are needed. I hope TiDB can be polished better, more refined, and more excellent :smile:.

| username: zhanggame1 | Original post link

Support requirements

| username: hey-hoho | Original post link

+1, using partitioned tables is troublesome, and not using them is also troublesome.

| username: Jellybean | Original post link

+1 Indeed.

| username: RenlySir | Original post link

Need my cousin to transfer this post to the demand pool.

| username: 天蓝色的小九 | Original post link

+1 Support the request

| username: TiDBer_vfJBUcxl | Original post link

+1 Support the request

| username: xfworld | Original post link

Hurry up and arrange it, the partitioning capability is becoming useless. :melting_face: :melting_face: :melting_face:

| username: h5n1 | Original post link

Some features in the roadmap can be put on hold, and performance improvement development should be prioritized. Even if version 7.5 is released together with partitioned KV, it is still an option.

| username: 像风一样的男子 | Original post link

+1 Support the request

| username: 裤衩儿飞上天 | Original post link

这是一个急需的功能。

| username: Billmay表妹 | Original post link

Feedback provided!

| username: ShawnYan | Original post link

Those in need can give a thumbs up here: