要查出的结果是:一次性根据相关联表字段查出5张表中与之相关多个字段列的信息,最少时会有1000多条,一条信息对应5种状态 请看以下续问EG: select f.procinsid,f.sqmc,f.lxrname,c.state,c.applydate,c.completedate,a.organization_name,f.xmgyxx,f.lxrmobile,f.lxrphone,f.lxremail,f.lxraddr from cwt_wf_casedata t, cm_casetimer c, tformcommondata f,app_organization a ,(select * from app_organization o where o.parent_organization = -1) ta,cm_state s where t.fprocinstid = c.procinsid and c.procinsid = f.procinsid and c.deptid = ta.organization_id and c.state = s.id and t.fprocinstid = '1371181' ---表ID号 and t.fexaminecodeinst like 'ZX08%';---表示流水号 如何给这个Oracle9i PLSQL Developer 中运行的SQL语句加上倒序查询关键与条件,加快它的查询效率?
请看以下续问EG:
select f.procinsid,f.sqmc,f.lxrname,c.state,c.applydate,c.completedate,a.organization_name,f.xmgyxx,f.lxrmobile,f.lxrphone,f.lxremail,f.lxraddr from cwt_wf_casedata t, cm_casetimer c, tformcommondata f,app_organization a
,(select * from app_organization o where o.parent_organization = -1) ta,cm_state s
where t.fprocinstid = c.procinsid
and c.procinsid = f.procinsid
and c.deptid = ta.organization_id
and c.state = s.id
and t.fprocinstid = '1371181' ---表ID号
and t.fexaminecodeinst like 'ZX08%';---表示流水号
如何给这个Oracle9i PLSQL Developer 中运行的SQL语句加上倒序查询关键与条件,加快它的查询效率?