cust_id 需要建索引
where A.AREA_CODE='591' AND A.PROD_TYPE IN (1,2,3,4) AND A.STATE<>'p' AND A.PLACE_S_NODE=B.PLACE_NODE AND B.PLACE_TYPE IN (0,3) AND B.COL2='1160' 把where条件部分改成这样试试
where A.AREA_CODE='591' AND A.PROD_TYPE IN (1,2,3,4) AND A.STATE<>'p' AND A.PLACE_S_NODE=B.PLACE_NODE AND B.PLACE_TYPE IN (0,3) AND B.COL2='1160'
17,140
社区成员
55,259
社区内容
加载中
试试用AI创作助手写篇文章吧