UPDATE [10.20.1.4].PanelZHSW.dbo.MES_MachineSpeed
SET MachineStatusCode = @Staus,
JORMNum = @_JORNum
WHERE FinishTime IS NULL
AND PM_MachineID = @MachineID
AND StartTime > DATEADD(dd, -1, GETDATE())
AND
(
ISNULL(MachineStatusCode, '') = ''
OR ISNULL(MachineStatusCode, '') = @Staus
); 这是我的修改语句,要6秒钟才能执行完,
这是表结构这是一张53W条数据的表格,请问大神这个应该如何去优化?
SET MachineStatusCode = @Staus,
JORMNum = @_JORNum
WHERE FinishTime IS NULL
AND PM_MachineID = @MachineID
AND StartTime > DATEADD(dd, -1, GETDATE())
AND
(
ISNULL(MachineStatusCode, '') = ''
OR ISNULL(MachineStatusCode, '') = @Staus
); 这是我的修改语句,要6秒钟才能执行完,
这是表结构这是一张53W条数据的表格,请问大神这个应该如何去优化?
WHERE FinishTime IS NULL
AND PM_MachineID = @MachineID
AND StartTime > DATEADD(dd, -1, GETDATE())
AND
(
ISNULL(MachineStatusCode, '') = ''
OR ISNULL(MachineStatusCode, '') = @Staus
); 上面这条语句执行一次需要多长时间?