cp模拟题问题

答案是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 |
+---------------+-----------------+------------+----------------+----------+---------------+-----------+----------+

不是说了oracle模式,你这里mysql模式吧

2 个赞

oracle默认global

oboracle创建索引默认全局索引。
当前使用的是obmysql模式,且社区版不支持oboracle模式

我的锅

那应该怎么选