一个可以加快Oracle查询语句性能的可能方法

这个方法就是：可以考虑使用/*+choose */  or /*+ no_index(w INDX_APP_ID) */  在select 语句中。

例如：

select * from (

 select /*+choose */ t.ssn, t.kana_alias, p.ntlogin, w.worktype_id,  w.application_id

  from feral.cs_kana_user@shade_prod t, ipop_participant p,ipop_worktype_lkp w

 where t.ssn = p.PARTICIPANT_ID

   and t.kana_alias = w.worktype_desc

   and p.PARTICIPANT_ID in

       (select participant_id

          from ipop_participant_group t, ipop_group g

         where t.group_id = g.group_id

           and g.group_desc = 'AU Manila Team')

   and lookup.newid2nodeid@shade_prod(t.kana_folder_id) = 6

) tt

where tt.application_id=6

select * from (

 select /*+ no_index(w INDX_APP_ID) */ t.ssn, t.kana_alias, p.ntlogin, w.worktype_id,  w.application_id

  from feral.cs_kana_user@shade_prod t, ipop_participant p,ipop_worktype_lkp w

 where t.ssn = p.PARTICIPANT_ID

   and t.kana_alias = w.worktype_desc

   and p.PARTICIPANT_ID in

       (select participant_id

          from ipop_participant_group t, ipop_group g

         where t.group_id = g.group_id

           and g.group_desc = 'AU Manila Team')

   and lookup.newid2nodeid@shade_prod(t.kana_folder_id) = 6

) tt

where tt.application_id=6