Can someone please recommend a solution for avoiding the clustered index scan on IX_secAssignment_MissionUnit?

jmnsprings 2017-05-27 15:46:40

I created a covering index on the Assignments table and it did seem to increase performance vs. a regular index on the same columns. I'm pretty new so I still take the approach of "scans are bad". Could someone please take a look and provide some focus on which objects I should try to tune through new indexes or query changes to the view. Thanks in advance.

Aaron Bertrand 2017-05-31 00:16:13
Could you possibly generate an actual plan from within Plan Explorer? With the additional runtime information and index analysis, it will be much easier to walk through and show whether a different index might be better. Please don't ever assume that scans are always bad – sometimes a scan is absolutely the most efficient way to get the data. See #2 here, #2 here, and this.