函数索引提高了扩展性
create or replace function getUpper(sName varchar2)
return varchar2
deterministic
as
---告诉oracle此函数是确定性 ——告诉oracle,给定相同值,不论调多少次,都会输出相同值。
begin
return upper(sName);
end;
create index ind_emp_fun on emp(getUpper(name));
select * from emp where getUpper(name)='SS'