答案是D
对应的SQL:
CREATE TABLE tb1 (id INT, name VARCHAR(30), age INT, phone VARCHAR(20), addr VARCHAR(100), PRIMARY KEY(id)) PARTITION BY HASH(id) PARTITIONS 16;
CREATE INDEX i1 ON tb1 (name);
CREATE index i2 ON tb1 (phone) GLOBAL;
CREATE INDEX i3 ON tb1 (age) GLOBAL PARTITION BY RANGE(age) (PARTITION p0 VALUES LESS THAN(18), PARTITION p1 VALUES LESS THAN(30), PARTITION p2 VALUES LESS THAN(60), PARTITION p3 VALUES LESS THAN(MAXVALUE));
这是实测的
obclient [test]> select DATABASE_NAME,TABLE_NAME,TABLE_TYPE,PARTITION_NAME,ROLE,DATA_TABLE_ID,OBJECT_ID,TABLE_ID from oceanbase.cdb_ob_table_locations where INDEX_NAME='i1' ;
+---------------+-----------------+------------+----------------+----------+---------------+-----------+----------+
| DATABASE_NAME | TABLE_NAME | TABLE_TYPE | PARTITION_NAME | ROLE | DATA_TABLE_ID | OBJECT_ID | TABLE_ID |
+---------------+-----------------+------------+----------------+----------+---------------+-----------+----------+
| test | __idx_500144_i1 | INDEX | p0 | LEADER | 500144 | 500161 | 500177 |
| test | __idx_500144_i1 | INDEX | p0 | FOLLOWER | 500144 | 500161 | 500177 |
| test | __idx_500144_i1 | INDEX | p0 | FOLLOWER | 500144 | 500161 | 500177 |
| test | __idx_500144_i1 | INDEX | p1 | LEADER | 500144 | 500162 | 500177 |
| test | __idx_500144_i1 | INDEX | p1 | FOLLOWER | 500144 | 500162 | 500177 |
| test | __idx_500144_i1 | INDEX | p1 | FOLLOWER | 500144 | 500162 | 500177 |
| test | __idx_500144_i1 | INDEX | p2 | LEADER | 500144 | 500163 | 500177 |
| test | __idx_500144_i1 | INDEX | p2 | FOLLOWER | 500144 | 500163 | 500177 |
| test | __idx_500144_i1 | INDEX | p2 | FOLLOWER | 500144 | 500163 | 500177 |
| test | __idx_500144_i1 | INDEX | p3 | LEADER | 500144 | 500164 | 500177 |
| test | __idx_500144_i1 | INDEX | p3 | FOLLOWER | 500144 | 500164 | 500177 |
| test | __idx_500144_i1 | INDEX | p3 | FOLLOWER | 500144 | 500164 | 500177 |
| test | __idx_500144_i1 | INDEX | p4 | LEADER | 500144 | 500165 | 500177 |
| test | __idx_500144_i1 | INDEX | p4 | FOLLOWER | 500144 | 500165 | 500177 |
| test | __idx_500144_i1 | INDEX | p4 | FOLLOWER | 500144 | 500165 | 500177 |
| test | __idx_500144_i1 | INDEX | p5 | LEADER | 500144 | 500166 | 500177 |
| test | __idx_500144_i1 | INDEX | p5 | FOLLOWER | 500144 | 500166 | 500177 |
| test | __idx_500144_i1 | INDEX | p5 | FOLLOWER | 500144 | 500166 | 500177 |
| test | __idx_500144_i1 | INDEX | p6 | LEADER | 500144 | 500167 | 500177 |
| test | __idx_500144_i1 | INDEX | p6 | FOLLOWER | 500144 | 500167 | 500177 |
| test | __idx_500144_i1 | INDEX | p6 | FOLLOWER | 500144 | 500167 | 500177 |
| test | __idx_500144_i1 | INDEX | p7 | LEADER | 500144 | 500168 | 500177 |
| test | __idx_500144_i1 | INDEX | p7 | FOLLOWER | 500144 | 500168 | 500177 |
| test | __idx_500144_i1 | INDEX | p7 | FOLLOWER | 500144 | 500168 | 500177 |
| test | __idx_500144_i1 | INDEX | p8 | LEADER | 500144 | 500169 | 500177 |
| test | __idx_500144_i1 | INDEX | p8 | FOLLOWER | 500144 | 500169 | 500177 |
| test | __idx_500144_i1 | INDEX | p8 | FOLLOWER | 500144 | 500169 | 500177 |
| test | __idx_500144_i1 | INDEX | p9 | LEADER | 500144 | 500170 | 500177 |
| test | __idx_500144_i1 | INDEX | p9 | FOLLOWER | 500144 | 500170 | 500177 |
| test | __idx_500144_i1 | INDEX | p9 | FOLLOWER | 500144 | 500170 | 500177 |
| test | __idx_500144_i1 | INDEX | p10 | LEADER | 500144 | 500171 | 500177 |
| test | __idx_500144_i1 | INDEX | p10 | FOLLOWER | 500144 | 500171 | 500177 |
| test | __idx_500144_i1 | INDEX | p10 | FOLLOWER | 500144 | 500171 | 500177 |
| test | __idx_500144_i1 | INDEX | p11 | LEADER | 500144 | 500172 | 500177 |
| test | __idx_500144_i1 | INDEX | p11 | FOLLOWER | 500144 | 500172 | 500177 |
| test | __idx_500144_i1 | INDEX | p11 | FOLLOWER | 500144 | 500172 | 500177 |
| test | __idx_500144_i1 | INDEX | p12 | LEADER | 500144 | 500173 | 500177 |
| test | __idx_500144_i1 | INDEX | p12 | FOLLOWER | 500144 | 500173 | 500177 |
| test | __idx_500144_i1 | INDEX | p12 | FOLLOWER | 500144 | 500173 | 500177 |
| test | __idx_500144_i1 | INDEX | p13 | LEADER | 500144 | 500174 | 500177 |
| test | __idx_500144_i1 | INDEX | p13 | FOLLOWER | 500144 | 500174 | 500177 |
| test | __idx_500144_i1 | INDEX | p13 | FOLLOWER | 500144 | 500174 | 500177 |
| test | __idx_500144_i1 | INDEX | p14 | LEADER | 500144 | 500175 | 500177 |
| test | __idx_500144_i1 | INDEX | p14 | FOLLOWER | 500144 | 500175 | 500177 |
| test | __idx_500144_i1 | INDEX | p14 | FOLLOWER | 500144 | 500175 | 500177 |
| test | __idx_500144_i1 | INDEX | p15 | LEADER | 500144 | 500176 | 500177 |
| test | __idx_500144_i1 | INDEX | p15 | FOLLOWER | 500144 | 500176 | 500177 |
| test | __idx_500144_i1 | INDEX | p15 | FOLLOWER | 500144 | 500176 | 500177 |
+---------------+-----------------+------------+----------------+----------+---------------+-----------+----------+
oboracle创建索引默认全局索引。
当前使用的是obmysql模式,且社区版不支持oboracle模式