SELECT XM_LCJGK.sjlc,Fw_Xxk.fwzt,XM_DYJGK.L_KEY,XM_DYJGK.T_ID,XM_DYJGK.D_COL,XM_DYJGK.YCS FROM INXMJY.XM_DYJGK
inner join INXMJY.XM_LCJGK on INXMJY.XM_DYJGK.L_key=INXMJY.XM_LCJGK.L_key
inner join INXMJY.fw_xxk on INXMJY.XM_DYJGK.GL_KEY=INXMJY.Fw_Xxk.GL_KEY
Where TRIM(XM_DYJGK.L_KEY)||TRIM (XM_DYJGK.J_KEY) in (SELECT trim(L_KEY)||trim(J_KEY) as uKey FROM INXMJY.XM_LCJGK where j_key= 100056620) order by Xm_lcjgk.L_id,XM_DYJGK.L_Key,XM_DYJGK.T_ID,XM_DYJGK.D_COL
这个语句的查询速度十分缓慢,各位大侠 帮我优化一下.
inner join INXMJY.XM_LCJGK on INXMJY.XM_DYJGK.L_key=INXMJY.XM_LCJGK.L_key
inner join INXMJY.fw_xxk on INXMJY.XM_DYJGK.GL_KEY=INXMJY.Fw_Xxk.GL_KEY
Where TRIM(XM_DYJGK.L_KEY)||TRIM (XM_DYJGK.J_KEY) in (SELECT trim(L_KEY)||trim(J_KEY) as uKey FROM INXMJY.XM_LCJGK where j_key= 100056620) order by Xm_lcjgk.L_id,XM_DYJGK.L_Key,XM_DYJGK.T_ID,XM_DYJGK.D_COL
这个语句的查询速度十分缓慢,各位大侠 帮我优化一下.
解决方案 »
- oracle查询为空时的问题,在线等
- Error while trying to retrieve text for error
- 一个关于oracel计算周末数的问题!!急啊!我们头等着要结果呢!
- exists的使用问题
- 我的ODBC数据源变为英文的了,如何改回来..?
- 将数据库设置为SUSPEND模式,为恢复直接断开连接,再次连接不上,该如何解决?
- 在Oracle中怎么实现Table1的所有记录导入到Table2中?
- 数据导入导出
- oracle中是否有sql中的功能,跟踪程序,查找那些有问题的进程
- oracle中的对象类型字段在delphi或vc中应如何访问
- oracle全文搜索引擎的问题
- 报出"ORA-29532:Java调用被未捕获的java例外终止:......",请问如何解决?
的组合索引。用exists替代in:Where exists (SELECT 1 where TRIM(XM_DYJGK.L_KEY)||TRIM (XM_DYJGK.J_KEY)=trim(L_KEY)||trim(J_KEY) j_key= 100056620) order by Xm_lcjgk.L_id,XM_DYJGK.L_Key,XM_DYJGK.T_ID,XM_DYJGK.D_COL
SELECT XM_LCJGK.sjlc,Fw_Xxk.fwzt,XM_DYJGK.L_KEY,XM_DYJGK.T_ID,XM_DYJGK.D_COL,XM_DYJGK.YCS
FROM INXMJY.XM_DYJGK
inner join INXMJY.XM_LCJGK on INXMJY.XM_DYJGK.L_key=INXMJY.XM_LCJGK.L_key
inner join INXMJY.fw_xxk on INXMJY.XM_DYJGK.GL_KEY=INXMJY.Fw_Xxk.GL_KEY
Where XM_DYJGK.J_KEY='100056620'
order by Xm_lcjgk.L_id,XM_DYJGK.L_Key,XM_DYJGK.T_ID,XM_DYJGK.D_COL
SELECT LCJGK.sjlc,
Fw_Xxk.fwzt,
XM_DYJGK.L_KEY,
XM_DYJGK.T_ID,
XM_DYJGK.D_COL,
XM_DYJGK.YCS
FROM INXMJY.XM_DYJGK
inner join INXMJY.fw_xxk on INXMJY.XM_DYJGK.GL_KEY =
INXMJY.Fw_Xxk.GL_KEY
inner join (SELECT XM_LCJGK.sjlc, XM_LCJGK.L_KEY, XM_LCJGK.J_KEY
WHERE j_key = 100056620) LCJGK ON (INXMJY.XM_DYJGK.L_key =
LCJGK.L_KEY AND
INXMJY.XM_DYJGK.J_KEY =
LCJGK.J_KEY)
order by Xm_lcjgk.L_id,
XM_DYJGK.L_Key,
XM_DYJGK.T_ID,
XM_DYJGK.D_COL