帮忙优化一下这个SQL查询语句，现在这个太慢啦

[lhw68500]

select w.*,
case when w.Bid in (select distinct WSe_Bid from WSend_phone) then '1' else '0' end as bianji,
(select top 1 sendflag from WSend_phone where WSe_Bid=w.bid ) as sendflag,
(select count(Recphone) from WSend_phone where WSe_Bid=w.bid ) as pcount from WSend_Business w

表WSend_phone和表WSend_Business 是多对一的关系 ，WSend_phone 中的WSe_Bid 对应WSend_Business 中的bid列，
谢谢各位啦！

[SQL77]

用联接方式吧,不要用子查询

[lhw68500]

有个求和，不是很好用连接

[lhw68500]

实际取的记录数只要WSend_Business 中的几条记录，但WSend_phone表中可能有上百万条记录，主要是取WSend_phone表中的求和消耗态度系统资源和时间，我通过查询分析器，分析过.

[soft_wsx]

in 改成 exists

[ADVANTECH_CYZ]

好NB的SQL语句呀。

[liangCK]

SELECT
    w.*,
    CASE WHEN ws.Wse_Bid IS NULL THEN 0 ELSE 1 END AS bianji,
    B.sendflag,B.pcount
FROM WSend_Business w
   LEFT JOIN (SELECT WSe_Bid,COUNT(Recphone) AS pcount,MIN(sendflag) AS sendflag
              FROM WSend_phone GROUP BY Wse_Bid) AS ws
ON w.bid = ws.Wse_Bid;

--这样试试

[lhw68500]

谢谢楼上这位大师！！！！！！！