在一个Oracle租户中,表tb1的DDL如下所示,该表上的哪个索引是全局索引?
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));
A.全部都是 B.i1 C.i2 D.i3