Last updated on May 1, 2026
OPTION (USE HINT ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_130'));--2016
OPTION (USE HINT ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140'));--2017
OPTION (USE HINT ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_150'));--2019
OPTION (USE HINT ('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_160'));--2022
OPTION (USE HINT ('FORCE_LEGACY_CARDINALITY_ESTIMATION'));--Forces the query optimizer to use Cardinality Estimation model of SQL Server 2012 and earlier versions. Equivalent to trace flag 9481 or Database Scoped Configuration setting LEGACY_CARDINALITY_ESTIMATION=ON.
OPTION (USE HINT ('ENABLE_QUERY_OPTIMIZER_HOTFIXES'));--Enables query optimizer hotfixes (changes released in SQL Server Cumulative Updates and Service Packs). Equivalent to trace flag 4199 or Database Scoped Configuration setting QUERY_OPTIMIZER_HOTFIXES=ON.
