select g.request_id,g.request_desc,h.id
from ecl_request_sheet g,
(select c.id,c.receiver_id from air_messages c,ecl_request_sheet d
where c.receiver_id=d.request_id
and c.msg_id not in(select msg_id from air_messages_act) ) h
where g.org_level=3 and g.request_desc is not null and g.request_desc!='none' and g.request_desc!='admin' and g.folder_id=0
start with g.request_id in h.receiver_id
connect by prior g.request_id=g.parent_id;
查询用了很久很久....,求高手找出问题所在及优化... 应该是分级查询那里影响效率的
度娘oracle执行计划,然后贴出来,才能帮你分析