为何关联表少了，速度反而慢了？

[gejxr]

SELECT '2003','04',XSTD_DWBH,XSTD_BMBH,XSTD_RYBH,XSTD_WBBH
,ROUND(SUM(ROUND(XSTDMX_BHSE,2)),2),0,0,ROUND(SUM(ROUND(XSTDMX_BHSE,2)),2),
ROUND(SUM(ROUND(XSTDMX_YHSE,2)),2),0,0,ROUND(SUM(ROUND(XSTDMX_YHSE,2)),2)
FROM XSTD,XSTDMX WHERE XSTD_TDLS=XSTDMX_TDLS and (XSTD_ZDRQ>='20010924' AND XSTD_ZDRQ<='20030323' AND XSTD_JZBZ='0') AND
XStd_RYBH IN ('001','002','003','004','005','006','007','008','010','011','012','013','014','015','016','017','018','019','020','021','022','023','024','025','026','028','029','030','031','032','033','034','035','036','037','038','039','040','041','042','043','044','045','046','047','049','050','051','052','053','054','055','056','057','058','059','060','062','063','064','065','066','067','068','069','070','071','072','073','074','075','076','078','080','081','082','083','085','086','087','088','089','090','091','094','095','096','097','098','099','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','301','999')
AND XSTD_CSBZ='0' AND XSTD_TDBZ<>'1'
GROUP BY XSTD_DWBH,XSTD_BMBH,XSTD_RYBH,XSTD_WBBH



SELECT '0000','00',XSTD_DWBH,XSTD_BMBH,XSTD_RYBH,XSTD_WBBH
,ROUND(SUM(ROUND(XSTDMX_BHSE,2)),2),0,0,ROUND(SUM(ROUND(XSTDMX_BHSE,2)),2),
ROUND(SUM(ROUND(XSTDMX_YHSE,2)),2),0,0,ROUND(SUM(ROUND(XSTDMX_YHSE,2)),2)
FROM XSTD,XSTDMX,ZWWLDW,KCBMZD,XSRYZD,LSWBZD
WHERE XSRYZD_RYBH IN ('001','002','003','004','005','006','007','008','010','011','012','013','014','015','016','017','018','019','020','021','022','023','024','025','026','028','029','030','031','032','033','034','035','036','037','038','039','040','041','042','043','044','045','046','047','049','050','051','052','053','054','055','056','057','058','059','060','062','063','064','065','066','067','068','069','070','071','072','073','074','075','076','078','080','081','082','083','085','086','087','088','089','090','091','094','095','096','097','098','099','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','301','999')
AND (XSTD_ZDRQ>='20010924' AND XSTD_ZDRQ<='20030323' AND XSTD_JZBZ='0')
AND XSTD_CSBZ='0' AND XSTD_TDBZ<>'1' AND XSTD_TDLS=XSTDMX_TDLS AND
XSTD_BMBH=KCBMZD_BMBH AND XSRYZD_RYBH=XSTD_RYBH AND XSTD_WBBH=LSWBZD_WBBH
AND XSTD_DWBH=ZWWLDW_DWBH
GROUP BY XSTD_DWBH,XSTD_BMBH,XSTD_RYBH,XSTD_WBBH

[mjhnet]

晕，好像并没有说明白

[javafish]

考虑用视图做一些数据处理先，然后在从视图中去数据嘛。你这个条件太复杂，系统分步处理时间都需要 很久

[gejxr]

通过执行计划显示：第1种没有利用xstdmx_tdls索引，执行时间50秒。第2种反而利用索引，只有5秒。但不知为何？