函数索引用不上请教
create table ppt1
(
dual varchar(8)
)
create table ppt2
(
dual varchar(8)
)
create index IDX_DZ_DF_TT_200902_4 on ppt1 (TO_NUMBER(dual))
create index IDX_DZ_DF_TT_200902_1 on ppt2 (TO_NUMBER(dual)+1)
select * from
ppt1 a,ppt2 b
where to_number(a.dual) = to_number(b.dual)+1
最后的执行计划用的全表扫