sql-server - SQL Server - 如何在更新命令上提示索引？

Question

我正在尝试执行以下命令来强制更新使用非聚集索引:

 UPDATE Flights 
 SET Airtime=5555678
 WHERE Distance=10000
 OPTION (TABLE HINT(Flights, INDEX (DistanceIndex)))

...并且出现错误:

Msg 8724, Level 16, State 1, Line 75
Cannot execute query. Table-valued or OPENROWSET function 'Flights' cannot be specified in the TABLE HINT clause.

我找不到任何关于如何在 TABLE HINT 语句中正确形成语法的明确建议。

请问谁能告诉我哪里出错了？

Answer 1

尝试以下操作:

UPDATE F
SET F.Airtime=5555678
FROM Flights F WITH (INDEX (DistanceIndex))
WHERE F.Distance=10000

或

UPDATE Flights
SET Airtime=5555678
FROM Flights -- this line is added to your initial query
WHERE Distance=10000
OPTION (TABLE HINT(Flights, INDEX (DistanceIndex)))