oracle sql查询语句优化

Question

各位大神，我想问下在生产PLSQL，将****内的注释以后，可以查询出结果（用时：16S秒），否则，SQL就一直处于执行状态，查询不出结果。在线等，求各位大神们解惑

select cs.P_VOICEDIAL_FLAG PVoicedialFlag,
   cs.pri_card_nbr priCardNbr,
   cs.total_bal totalBal,
   cs.overdue_amount totalOdue,
   cs.risk_score riskScore,
   ci.instant_queue_user instantQueueUser,
   ci.assist_user assistUser,
   ci.dept_id dept,
   de.name_ deptName,
   ci.allot_reason allotReason,
   (trunc(ci.close_datetime) - trunc(sysdate) + 1) validateDay,
   cs.ab_branch branch,
   ci.case_business_type caseBusinessType,
 ****  ci.case_list_state caseListSate,--队列名称
   ci.CASE_CODE caseId,--案件编号
   ci.CUST_NAME cName,--客户姓名
        ****
   ci.cust_nbr idNumber,
   ci.instant_queue instantQueue,
   cs.BILL_DATE billingDate,
   cs.total_debt totalAmount,
   cs.MOTHS moths,
   cs.capital capital,
   ci.FOLLOW_DATE followDate,
   cs.PTP_FLAG promiseFlg,
   ci.COLLECTOR currCollector,
   ci.team_code currTeam,
   cs.date_into_collect inputDate,
   ci.ALLOT_DATE alloDate,
   ci.ALLOT_USERNAME alloName,
   ci.model_code modelCode

from armc_case_info ci
left outer join bdf2_dept de
on ci.bank_code = de.company_id_
and ci.dept_id = de.id_
left outer join ARMC_CUST_SUM cs
on ci.bank_code = cs.bank_code
and ci.inst_code = cs.inst_code
and ci.cust_nbr = cs.cust_nbr
and ci.biz_type = cs.biz_type
left outer join ARMC_CASE_STATE st
on ci.bank_code = st.bank_code
and ci.inst_code = st.inst_code
and ci.cust_nbr = st.cust_nbr
and ci.biz_type = st.biz_type
where 1 = 1
and cs.safe_mode_flag = 0
and ci.model_code = 'TDC'
and ci.curr_state = 'OPE'
and ci.case_business_type != 'WITH'
ORDER BY cs.total_debt desc

Answer 1

http://www.cnblogs.com/netjxz/archive/2009/09/21/1570991.html