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));"
A. i3
B. i2
C. i1
D. 全部都是
1 个赞
题目略长啊,选D吧
1 个赞
不错~