整理一下Oracle数据查询索引命中情况,仅供参考,有问题欢迎指出修正:
创建测试表:
CREATE TABLE TEST_HZ
(
A VARCHAR(20),
B VARCHAR(20),
C VARCHAR(20)
);
插入数据: 本人比较懒,然后就直接建序列插数据
create sequence seq_test_hz_a
start with 1
increment by 1
maxvalue 99999999999999999
nominvalue
nocycle
nocache;
create sequence seq_test_hz_b
start with 1
increment by 1
maxvalue 99999999999999999
nominvalue
nocycle
nocache;
create sequence seq_test_hz_c
start with 1
increment by 1
maxvalue 99999999999999999
nominvalue
nocycle
nocache;
INSERT INTO TEST_HZ VALUES(seq_test_hz_a.nextval,seq_test_hz_b.nextval,seq_test_hz_c.nextval)
直接跑,想要多少条数据就跑多少次就好
**************** 对A,B,C只创建联合索引 IDX_ABC **********************
CREATE INDEX IDX_ABC ON