oracle 优化表索引,【有一条sql优化好几张表都走全表扫描，不明白为什么不走索引，请大家帮忙看下】...

select a.case_id,

a.case_type_id,

a.case_sub_type_id,

a.create_employee_id,

a.dept_id,

a.customer_name,

a.card_type_id,

a.lock_employee_id,

a.case_status,

a.customer_mobile,

a.operate_time,

a.customer_card_id,

b.case_type_name,

c.case_sub_type,

e.dept_name,

f.employee_name      as createdemployee,

g.card_type_name,

p.employee_name      as operatename,

di.dept_name         as deptname,

ep.position_name,

a.order_type_id,

a.order_id

from t_s_case a

inner join t_sd_case_type b

on a.case_type_id = b.case_type_id

left join t_s_case_sub_type c

on a.case_sub_type_id = c.case_sub_type_id

inner join t_s_employee f

on a.create_employee_id = f.employee_id

left join t_s_department e

on e.dept_id = a.dept_id

left join t_mc_card_type g

on a.card_type_id = g.card_type_id

left join t_s_case_operation_record h

on h.case_id = a.case_id

left join t_s_employee p

on p.employee_id = h.employee_id

left join t_s_department di

on di.dept_id = f.dept_id

left join t_sd_emplyee_position ep

on ep.position_id = a.position_id

order by a.case_id desc

为什么不走索引呢，好几个表都走的全表扫描？

附件是pl/sql/developer 中的执行计划

未命名.jpg

(104.16 KB, 下载次数: 10)

2013-4-24 15:08 上传

sql执行计划图