Hot answers tagged execution-plan
To get a clustered index seek, you'd need a clustered index that supports your filter (e.g. leading key would have to be Personal_ID, not ID). You can't force a seek if there's no index with a leading column of Personal_ID that supports the filter. This does not mean you should change the existing clustered index, unless this is the only query you ever ...
Only top voted, non community-wiki answers of a minimum length are eligible