Can someone please recommend a solution for avoiding the clustered index scan on IX_secAssignment_MissionUnit?
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.