关于索引问题

用函数索引代替like用法

create table test(

id varchar2(20),

name varchar2(20),

time date);

create index index_test on test(substr(name,1,1));

select * from test where name like 'd%'

select * from test where substr(name,1,1)='d'

使用substr函数索引代替like明显加快查询速度

create index index_time on test(to_date(time,'yyyy-mm-dd'));

select time from test where to_date(time,'yyyy-mm-dd')>='2005-1-1'