SELECT distinct col from v_view1 where datetime1 between to_date('20010101','yyyymmdd') and datetime1 and to_date('20030508','yyyymmdd') and instr(string1,'13302') and flag='1';
create index ix_datetime1 on v_view1(datetime1); create index ix_flag on v_view1(flag);
2.去掉trunc,to_date('20030508','yyyymmdd') 改成to_date('20030508','yyyymmdd')+0.99999
where datetime1 between to_date('20010101','yyyymmdd')
and datetime1 and to_date('20030508','yyyymmdd')
and instr(string1,'13302')
and flag='1';
create index ix_datetime1 on v_view1(datetime1);
create index ix_flag on v_view1(flag);