我有一条SQL语句,分拆如下:A = select a.start_usid from table a start with a.objectid = objectId
connect by a.end_usid=prior a.start_usid
B =
select a.objectid,a.length,a.start_usid,a.end_usid,a.sort,a.work_id from table2 a start with a.end_usid in A connect by nocycle a.end_usid=prior a.start_usid
C = select a.*,t.end_usid as next_start_usid from B a left join table2 t on a.start_usid=t.end_usid速度很慢,请牛人帮忙!
connect by a.end_usid=prior a.start_usid
B =
select a.objectid,a.length,a.start_usid,a.end_usid,a.sort,a.work_id from table2 a start with a.end_usid in A connect by nocycle a.end_usid=prior a.start_usid
C = select a.*,t.end_usid as next_start_usid from B a left join table2 t on a.start_usid=t.end_usid速度很慢,请牛人帮忙!
解决方案 »
- 从ORACLE导入数据库结构和数据到SQLSERVER的问题!
- sql语句执行计划优化,在线等~~~~~~
- 》》》》》》》高手救命:怎么根据子表的内容触发主表?
- Oracle 数据字典 long -> varchar2
- log_buffer参数问题
- 问一个order by的问题,在这里只能散100,昏迷
- 如何获取Blob/long raw字段的真实长度?
- oracle安装完之后出现的问题
- 两张表的合并更新问题
- 如何使Windows2000中的Oracle 8.1.6的ManagementServer服务在启动操作系统后自动启动;
- Oracle
- ORA-12154: TNS: 无法解析指定的连接标识符
select a.*,t.end_usid as next_start_usid from
(select a1.objectid,a1.length,a1.start_usid,a1.end_usid,a1.sort,a1.work_id
from table2 a1
where exists(select 1 from table a where a1.end_usid=a.start_usid
start with a.objectid = objectId
connect by a.end_usid=prior a.start_usid)
start with a1.end_usid connect by nocycle a1.end_usid=prior a1.start_usid) a
left join table2 t on a.start_usid=t.end_usid
--你还是把你涉及到的表结构列出来,再列出些数据,和你要的结果