一个奇怪的问题请高手帮忙 在线等
declare @Begintime datetime,
@Endtime datetime
Select @Begintime='2005-5-1 00:00:01'
Select @Endtime= '2005-5-31 23:59:59'
DELETE Fee_DetailBillTemp
FROM Fee_DetailBillTemp INNER JOIN
Fee_TaskTrace ON
Fee_TaskTrace.TaskID = Fee_DetailBillTemp.TaskID INNER JOIN
Fee_CallLog ON
Fee_CallLog.CallID = Fee_TaskTrace.CallID
WHERE (Fee_CallLog.BeginTime > @endtime ) AND
(Fee_CallLog.CallType = '1')
这样在查询分析器里面执行的话回一直在运行, 将where 中的@endtime直接替换成'2005-5-31 23:59:59'就只要几秒就执行完了,这是怎么回事?
DELETE Fee_DetailBillTemp
FROM Fee_DetailBillTemp INNER JOIN
Fee_TaskTrace ON
Fee_TaskTrace.TaskID = Fee_DetailBillTemp.TaskID INNER JOIN
Fee_CallLog ON
Fee_CallLog.CallID = Fee_TaskTrace.CallID
WHERE (Fee_CallLog.BeginTime > '2005-5-31 23:59:59' ) AND
(Fee_CallLog.CallType = '1')
这样只要2秒