oracle---给表创建函数索引

发布时间：2020-12-12 15:07:29 所属栏目：百科来源：网络整理

导读：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_,empshebao

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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!