select zyq.qyqc as 作业区,
INF_CompanyInfo.QYQC as 小队,
zyq.cid,zyq.fcid,INF_CompanyInfo.Cid,INF_CompanyInfo.fcid,
t.jb_name,
t.jb_zt,
t.jb_bs
from TESTDATA a,
v_jbANDuserINFO t,
R_CompanyAndYJJTAS,
INF_CompanyInfo,
INF_CompanyInfo zyq
where t.xm_value = 'TESTDATA'
and t.jb_BS = 'jh=' || '''' || a.jh || '''' || ',rq=' || '''' || a.rq || '''' ||
',CSRQ=' || '''' || a.csrq || ''''
and a.jh = R_CompanyAndYJJTAS.jh
and substr(a.rq, 1, 7) = R_CompanyAndYJJTAS.rq
and INF_CompanyInfo.cid = R_CompanyAndYJJTAS.cid
and zyq.cid = INF_CompanyInfo.fcid
and t.utid = '18'
and INF_CompanyInfo.fcid = '20101124103354000'
and INF_CompanyInfo.cid = '20101124103856156'这是我的查询语句,加上最后一个查询条件时,速度变的非常慢,是原来的几十倍。是不是语句我哪里写的有问题。INF_CompanyInfo这个表的cid和fcid是树形结构的两个字段。大家帮我看看哪里有的问题,多谢了
INF_CompanyInfo.QYQC as 小队,
zyq.cid,zyq.fcid,INF_CompanyInfo.Cid,INF_CompanyInfo.fcid,
t.jb_name,
t.jb_zt,
t.jb_bs
from TESTDATA a,
v_jbANDuserINFO t,
R_CompanyAndYJJTAS,
INF_CompanyInfo,
INF_CompanyInfo zyq
where t.xm_value = 'TESTDATA'
and t.jb_BS = 'jh=' || '''' || a.jh || '''' || ',rq=' || '''' || a.rq || '''' ||
',CSRQ=' || '''' || a.csrq || ''''
and a.jh = R_CompanyAndYJJTAS.jh
and substr(a.rq, 1, 7) = R_CompanyAndYJJTAS.rq
and INF_CompanyInfo.cid = R_CompanyAndYJJTAS.cid
and zyq.cid = INF_CompanyInfo.fcid
and t.utid = '18'
and INF_CompanyInfo.fcid = '20101124103354000'
and INF_CompanyInfo.cid = '20101124103856156'这是我的查询语句,加上最后一个查询条件时,速度变的非常慢,是原来的几十倍。是不是语句我哪里写的有问题。INF_CompanyInfo这个表的cid和fcid是树形结构的两个字段。大家帮我看看哪里有的问题,多谢了
如果是number類型,這樣寫的話,要進行類型轉換,會很耗時間。
and INF_CompanyInfo.fcid = '20101124103354000'
and INF_CompanyInfo.cid = '20101124103856156'