tencent cloud

create table t1 (
  a bigint unsigned not null  PRIMARY KEY,
  b varchar(16) not null,
  pad varchar(128) not null,
  key key_b(b) global   -- 增加 global 关键字，在建表中指定全局索引
)
PARTITION BY RANGE(a) (
  PARTITION p0 VALUES LESS THAN (10000000),
  PARTITION p1 VALUES LESS THAN (20000000),
  PARTITION p2 VALUES LESS THAN (30000000),
  PARTITION p3 VALUES LESS THAN (MAXVALUE)
);

create index key_b on t1(b) global; -- 增加 global 关键字，在建索引中指定全局索引
alter table t1 add index key_b(b) global;