create or replace view v_biz_hadhandled as
select f1.*,f3.flowstepname as nextworkname from
(select ff.*,j.cetf_id,j.live_address,j.rpr_live_jd
from t_biz_hadhandled ff,v_jz_app p,jz_basic_person j
where ff.biztableid=p.pid(+)
and j.pid=p.person_id
and ff.person_name is not null
union all
select ff.*,null,null,null from t_biz_hadhandled ff where ff.person_name is null
)f1,(
select f.biztableid,MAX(F.PCTIME)
AS max_pctime,max(f.flowstep)
as max_flowstep from t_biz_hadhandled f
group by f.biztableid,f.senderid
) f2,t_bizwaithandle f3
where f1.biztableid=f2.biztableid
and f1.pctime=f2.max_pctime
and f1.flowstep=max_flowstep
and f3.biztableid(+)=f1.biztableid
;
我已经建立了索引，但感觉速度还是不理想，想问问各位大哥看这个语句能不能修改下，使查询更快。
------解决方案--------------------
- SQL code
create or replace view v_biz_hadhandled asselect ff.*, j.cetf_id, j.live_address, j.rpr_live_jd, f3.flowstepname as nextworkname from t_biz_hadhandled ff left join v_jz_app p on ff.biztableid = p.pid and ff.person_name is not null left join jz_basic_person j on j.pid = p.person_id left join t_bizwaithandle f3 on f3.biztableid = ff.biztableid where exists (select 1 from t_biz_hadhandled where biztableid = ff.biztableid group by senderid having MAX(PCTIME) = ff.pctime and max(flowstep) = ff.flowstep)