Key Lookup does not go away
ID, column included ContractNBR, CustomerID and Vehicle ID
Contract, column included CustomerID, DealerID, ID, and Vehicle ID
Any help would be really appreciated.
CREATE INDEX [IX Sales.Contract DealerID (ContractNbr, CustomerID, VehicleID)] ON Sales.Contract (DealerID) INCLUDE ContractNbr, CustomerID, VehicleID, ID;
…or adjust the existing index NDX_DealerID accordingly.