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

Question

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

Answer 1

将此查询做一个视图，应该查询速度会快点
望兄弟以后写规范点，将表以别名代替，自己和别人看起来都不累，我帮你改的：
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'))

Answer 2

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