create table xyq (id1 number,id2 varchar2(2))
insert into xyq values(1,'2');
insert into xyq values(1,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(1,'2');
insert into xyq values(1,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(2,2);
create index xyqa on xyq (id1)
select *from xyq where id1='2';--索引
select *from xyq where id2=2;--全表扫描
select *from xyq where id2='2'; --索引
insert into xyq values(1,'2');
insert into xyq values(1,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(1,'2');
insert into xyq values(1,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(2,'2');
insert into xyq values(2,2);
create index xyqa on xyq (id1)
create index xyqb on xyq (id2)
select *from xyq where id1='2';--索引
select *from xyq where id2=2;--全表扫描
select *from xyq where id2='2'; --索引