1:
SQL> explain plan set statement_id ='test' for
2
2 select c.cred_id, d.new_id
3 from temp1 a,
4 t_cc_l0_crediantial c,
5 temp_etl_p10ids_oldnewid d,
6 t_cc_party_policy_ass b
7 where a.policy_id = b.policy_id
8 and b.party_id = c.party_id
9 and c.idcard_no = d.old_id
10 and b.enable_flg = '1'
11 and c.enable_flg = '1'
12 and c.idcard_type_cd = '1170010001'
13 ;
2:
select * from table(dbms_xplan.display('plan_table','test'));
3,如在pl/sql dev 中执行,可能某些地方显示不全。故在sql windows 中执行.