SQL Server-如何在更新命令上提示索引? [英] SQL Server - How to Hint an Index on an Update command?

问题描述

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

I'm trying to execute the following command to force an update to use a non-clustered index:

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

...这是错误的:

消息8724，第16级，状态1，第75行
无法执行查询.不能在TABLE HINT子句中指定表值或OPENROWSET函数航班".

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语句中形成语法，我找不到任何明确的建议.

I can't find any clear advice on how the syntax should be properly formed inside the TABLE HINT statement.

请问有人可以告诉我我要去哪里错了吗?

Please can anyone advise where I'm going wrong?

推荐答案

尝试以下操作:

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)))

这篇关于SQL Server-如何在更新命令上提示索引?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！