Unexpected index scan instead of seek on update

by Luke   Last Updated May 28, 2018 10:06 AM

We have a third party application which is performing badly. An update statement is performing a scan instead of a seek, and is not suggesting a missing index. Why is this happening?

I was expecting the execution plan to suggest a missing index like

create nonclustered index [ix_FluxInbox_tasklockedby] on Flux.dbo.FluxInbox (tasklockedby) include (tasklockedrole, tasklockedon)

Below is the execution plan enter image description here

The details of the index scan

enter image description here

Related Questions

Enhance query performance using index and cluster

Updated March 28, 2018 17:06 PM

SQl code performance

Updated January 15, 2018 16:06 PM