sql - 更新语句执行时间过长

Question

我正在运行一个简单的更新语句。执行时间太长。这是更新和索引的详细信息。

导出列的默认值为 0

UPDATE PAR_ITM SET exported = -1 WHERE exported < 1

索引:

CREATE NONCLUSTERED INDEX [IX_PAR_ITM_Exported_1]
ON [dbo].[PAR_ITM] ([exported] ASC)
WITH (
  PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = ON, SORT_IN_TEMPDB = OFF,
  IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON,
  ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80
) ON [PRIMARY]

Answer 1

因此，您将导出设置为 -1，其中导出已等于 -1。也许将您的 was 子句更改为 WHERE export = 0 会减少行数？