遇到一个sqlserver奇怪的问题
select top 20 UID,sum(ml_WinMoney) from M_T_WinMoney_List
where uid not in
(select For_UID from Win_Basis.dbo.B_T_Member_ZhiShiTong_VIP)
and For_mt_ID='0201' and ml_AddTime>'2013-10-01 00:00:00' and ml_AddTime<='2013-10-31 23:59:59' group by UID order by sum(ml_WinMoney)
出现的奇怪的问题是:我取10月份的数据没有问题,但是取11月份的数据就一直是超时,这是什么原因呢
请教大神们,感谢!
[解决办法]
1、用11月的参数生成预估执行计划看看。
2、重编译一下试试