Archiving and the SQL Server database

Microsoft SQL Server 2014 introduced a new optimizer cardinality estimator. The use of this optimizer creates suboptimal plans during archiving, which can eventually lead to deadlocks on SQL Server. Guidewire disables this optimizer by adding a database hint at the end of the archiving UPDATE statement.