2007年
-
编辑 删除
访问视图没有走基本表索引
开发人员报告：有如下的sql性能差：select rowid,PKG_LIFE_QUERY_FUNC.F_GET_DEPOSIT_ACCOUNT_VALUE(DEPOSIT_ID,ACCOUNT_CODE) as ACCOUNT_VALUE,PKG_LIFE_QUERY_FUNC.F_GET_DEPOSIT_ACCOUNT_VALUE(DEPOSIT_ID,ACCOUNT_CODE) as ACCOUNT_VALUE,a.* from V_CUST_DEPOSIT_LIST a where ( account_code='27902') V_CUST_DEPOSIT_LIST 是一个视图如下：create or replace view v_cust_deposit_list as select row_number() over(order by tcdl.account_code, trunc(tcdl.deposit_date), to_number(decode(tcd.distri_type, '1', 1, '2
