Force SQL Server Version Compatibility with Query Hints
OPTION (USE HINT (‘QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_130’));–2016OPTION (USE HINT (‘QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140’));–2017OPTION (USE HINT (‘QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_150’));–2019OPTION (USE HINT (‘QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_160’));–2022OPTION (USE HINT (‘FORCE_LEGACY_CARDINALITY_ESTIMATION’));–Forces the query optimizer to use Cardinality Estimation model of SQL Server 2012 and earlier …
