34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT DepartmentID,EmployeeID,TransactionType,RecordTime,RateOfProgressType,IsTransfer from vw_ClientInfoList where IsDelete=0 AND IsEffective=1 AND IsSigning=0 AND RecordTime<='2016/7/28 5:00:00'
SELECT DepartmentID ,
EmployeeID ,
TransactionType ,
RecordTime ,
RateOfProgressType ,
IsTransfer
FROM vw_ClientInfoList
WHERE IsDelete = 0
AND IsEffective = 1
AND IsSigning = 0
AND RecordTime <= '2016/7/28 5:00:00';
--Ctrl + L 查看执行计划,看看具体是哪儿慢了.
/*
如果是表,看看碎片, 建立响应的索引.
如果是视图,除上述表的操作外.
可以考虑使用索引视图.(这个还要看lz的视图是否满足索引视图要求)
*/
索引视图https://msdn.microsoft.com/zh-cn/library/ms191432.aspx