It sounds like col12 is the identity, but col4 also needs to be unique too; if col4 does not need to be maintained for any integrity, then the row_number should...
Most likely the data volume in production reached a threshold which caused the change in the execution plan based on the SQL internal standards. Unless your test/uat servers have the...
This reply was modified 5 years, 5 months ago by carlanders.