请大侠帮忙解决这条语句的执行效率问题？

[asplhk]

我用ADO。NET从ORACLE806数据库中检索数据，十几行的数据竟然需要90秒钟才能搞定，请帮忙优化
语句如下：
SELECT PG_JSJCS_ZB.CSGS||PG_JSJCS_FA_ZB.ZBCSZ zbmx,PG_PGRD_PGXXMX.PGSQ,DJ_NSRXX.NSRMC,PG_JSJCS_ZB.CSGS,PG_JSJCS_ZB.TSXX,PG_JSJCS_ZB.ZBYSSL,PG_JSJCS_ZB.ZBYSMC01,PG_JSJCS_ZB.ZBYSMC02,PG_JSJCS_ZB.ZBYSMC03,PG_JSJCS_ZB.ZBYSMC04,PG_JSJCS_ZB.ZBYSMC05,PG_JSJCS_ZB.ZBYSMC06,PG_JSJCS_ZB.ZBYSMC07,PG_JSJCS_ZB.ZBYSMC08,PG_JSJCS_ZB.ZBYSMC09,PG_JSJCS_ZB.ZBYSMC10,PG_JSJCS_ZB.ZBYSMC11,PG_JSJCS_ZB.ZBYSMC12,PG_JSJCS_ZB.ZBYSMC13,PG_JSJCS_ZB.ZBYSMC14,PG_JSJCS_ZB.ZBYSMC15,PG_JSJCS_ZB.ZBYSMC16,PG_JSJCS_ZB.ZBYSMC17,PG_JSJCS_ZB.ZBYSMC18,PG_JSJCS_ZB.ZBYSMC19,PG_JSJCS_ZB.ZBYSMC20,PG_PGRD_PGXXMX.ZBYSZ01,PG_PGRD_PGXXMX.ZBYSZ02,PG_PGRD_PGXXMX.ZBYSZ03,PG_PGRD_PGXXMX.ZBYSZ04,PG_PGRD_PGXXMX.ZBYSZ05,PG_PGRD_PGXXMX.ZBYSZ06,PG_PGRD_PGXXMX.ZBYSZ07,PG_PGRD_PGXXMX.ZBYSZ08,PG_PGRD_PGXXMX.ZBYSZ09,PG_PGRD_PGXXMX.ZBYSZ10,PG_PGRD_PGXXMX.ZBYSZ11,PG_PGRD_PGXXMX.ZBYSZ12,PG_PGRD_PGXXMX.ZBYSZ13,PG_PGRD_PGXXMX.ZBYSZ14,PG_PGRD_PGXXMX.ZBYSZ15,PG_PGRD_PGXXMX.ZBYSZ16,PG_PGRD_PGXXMX.ZBYSZ17,PG_PGRD_PGXXMX.ZBYSZ18,PG_PGRD_PGXXMX.ZBYSZ19,PG_PGRD_PGXXMX.ZBYSZ20,PG_PGRD_PGXXMX.ZB_DM,PG_PGRD_PGXXMX.ZBQZ,PG_PGRD_PGXXMX.ZBSHJG,PG_PGRD_PGXXMX.ZBYSYC_DM,PG_JSJCS_ZB.ZB_MC,PG_PGRD_PGXXMX.CSRWXH,PG_PGRD_PGXXMX.NSRSBH FROM PG_JSJCS_FA_ZB,PG_JSJCS_ZB,PG_PGRD_PGXXMX,DJ_NSRXX WHERE (PG_PGRD_PGXXMX.FA_DM=PG_JSJCS_FA_ZB.FA_DM) and (PG_PGRD_PGXXMX.ZB_DM=PG_JSJCS_FA_ZB.ZB_DM) and (PG_PGRD_PGXXMX.ZB_DM=PG_JSJCS_ZB.ZB_DM) and (PG_PGRD_PGXXMX.NSRSBH=DJ_NSRXX.NSRSBH ) and ((PG_PGRD_PGXXMX.NSRSBH ='41072617335371X') AND (PG_PGRD_PGXXMX.PGSQ ='2003-08'))

[gshope]

晕！这么多字段！

[siugwan]

可能用inner join会好一点

[siugwan]

晕！这么多字段！
如inner join PG_JSJCS_ZB on PG_PGRD_PGXXMX.FA_DM=PG_JSJCS_FA_ZB.FA_DM

[liuvb]

晕了，帮你顶，

[wangsaokui]

将此查询做一个视图，应该查询速度会快点
望兄弟以后写规范点，将表以别名代替，自己和别人看起来都不累，我帮你改的：
SELECT B.CSGS||A.ZBCSZ，
B.ZB_MC,
zbmx,
C.PGSQ,
D.NSRMC,
B.CSGS,
B.TSXX,
B.ZBYSSL,
B.ZBYSMC01,
B.ZBYSMC02,
B.ZBYSMC03,
B.ZBYSMC04,
B.ZBYSMC05,
B.ZBYSMC06,
B.ZBYSMC07,
B.ZBYSMC08,
B.ZBYSMC09,
B.ZBYSMC10,
B.ZBYSMC11,
B.ZBYSMC12,
B.ZBYSMC13,
B.ZBYSMC14,
B.ZBYSMC15,
B.ZBYSMC16,
B.ZBYSMC17,
B.ZBYSMC18,
B.ZBYSMC19,
B.ZBYSMC20,
C.ZBYSZ01,
C.ZBYSZ02,
C.ZBYSZ03,
C.ZBYSZ04,
C.ZBYSZ05,
C.ZBYSZ06,
C.ZBYSZ07,
C.ZBYSZ08,
C.ZBYSZ09,
C.ZBYSZ10,
C.ZBYSZ11,
C.ZBYSZ12,
C.ZBYSZ13,
C.ZBYSZ14,
C.ZBYSZ15,
C.ZBYSZ16,
C.ZBYSZ17,
C.ZBYSZ18,
C.ZBYSZ19,
C.ZBYSZ20,
C.ZB_DM,
C.ZBQZ,
C.ZBSHJG,
C.ZBYSYC_DM,
C.CSRWXH,
C.NSRSBH
FROM PG_JSJCS_FA_ZB A,
PG_JSJCS_ZB B,
PG_PGRD_PGXXMX C,
DJ_NSRXX D
WHERE (C.FA_DM=A.FA_DM) and
(C.ZB_DM=A.ZB_DM) and
(C.ZB_DM=B.ZB_DM) and
(C.NSRSBH=D.NSRSBH ) and
((C.NSRSBH ='41072617335371X') AND
(C.PGSQ ='2003-08'))

[iyond]

果然是牛人！花了眼了，换眼镜ing

[dotnetfanlhk]

检查一下表的索引