使用 INDEX 优化器提示

-- Use the specifically namedINDEX.
USE AdventureWorks ;
GOSELECTc.FirstName, c.LastName, e.Title
FROM HumanResources.Employee e WITH (INDEX(IX_Employee_ManagerID))
JOIN Person.Contact c on e.ContactID = c.ContactID
WHERE ManagerID = 2 ;
GO

-- Force a table scan by usingINDEX= 0.
USE AdventureWorks ;
GOSELECTc.LastName, c.FirstName, e.Title
FROM HumanResources.Employee e WITH (INDEX= 0) JOIN Person.Contact c
ON e.ContactID = c.ContactID
WHERE LastName = 'Johnson' ;
GO