---优化后 减少解析次数  
SELECT d.brxm00, d.brid00
  FROM  yj_yw0000 b, bm_brxxb0 d,xk_jcpxbg a, xk_sxsq00 c
 WHERE a.xyyjdh = b.yjdjh0
   AND c.brid00 = d.brid00
   AND c.sqdh00 = a.sqdh00
   AND b.xmzt00 = 2
   AND a.cxbz00 <> 'N'
   AND a.xdbh00 = '1008293102'
   
   
---优化前
SELECT d.brxm00, d.brid00
  FROM xk_jcpxbg a, yj_yw0000 b, xk_sxsq00 c, bm_brxxb0 d
 WHERE a.xyyjdh = b.yjdjh0
   AND b.xmzt00 = 2
   AND c.brid00 = d.brid00
   AND c.sqdh00 = a.sqdh00
   AND a.cxbz00 <> 'N'
   AND a.xdbh00 = '1008293102'