Published 20 November 2017
SET FORCEPLAN used
It is not recommended to use SET FORCEPLAN ON because of the possibility of performance degradation.
SET FORCEPLAN ON overrides the logic used by the query optimizer to process a Transact-SQL SELECT statement. It prevents the optimizer from changing the order in which SQL Server processes the tables to satisfy the query. It is very unlikely to be useful.