select empshebaog0_.c_xianzhong as c1_,empshebaog0_.c_code as c2_249_,empshebaog0_.c_employeeid as
c3_249_,empshebaog0_.person_base as person4_249_,empshebaog0_.person_bl as person5_249_,
empshebaog0_.company_base as company6_249_,empshebaog0_.company_bl as company7_249_,
empshebaog0_.c_gjjjnd as c8_249_,empshebaog0_.c_sbjnd as c9_249_ from TB_V_EMP_BX_GJJ_INFO

empshebaog0_ where empshebaog0_.c_code=821337 order by empshebaog0_.c_xianzhong

这条sql语句增加一个函数索引

create index cd_zs.idx_TB_INF_EMPLOYEE10 on cd_zs.TB_INF_EMPLOYEE(TO_NUMBER(C_CODE)) online tablespace tb42;

原文链接：https://www.f2er.com/oracle/209878.html