由于涉及到一些重要数据不能展现,所以只能用测试表:
create table test as select * from dba_object;
create index ind_sb1 on test(owner,object_name);
explain plan for
select COUNT(*) from test where owner='SCOTT' and substr(object_name,1,length('123'))= '123';
优化后
select COUNT(*) from test where owner='SCOTT' and object_name like '123%';
不知道开发咋想的,所以在我们写sql的过程中,函数不能乱用