After more research I found it is also affecting cascade deletes as well.  Enabling trace flag 2363 shows "Calculator failed. Replanning." and then coming up with "Selectivity: 1" (everything in...

Yes, I know if I turn Legacy Cardinality Estimation on it works - unfortunately since its on SQL 2014 compatibility it would possibly introduce regressions.  I found what appears to...

Here is what I used to create the plan scenario, I am unable to share what is running in production but it is more complex with much more data.  I...

It is an OLTP environment.  We have considered column-store indexes but based frequent base table updates decided against it.  The data does need to be real-time.  We are not able...