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.

Available in

 SQL Monitor

SQL Prompt

 SQL Code Guard