OPTIMIZE FOR and RECOMPILE address parameter-sensitive plans differently; compare stable representative values with per-run compilation cost.
Row Goals: Why TOP and EXISTS Change the Plan
Inspect row goals from TOP and EXISTS, read EstimateRowsWithoutRowGoal, and compare a targeted optimizer hint using actual plans.
SQL Server – Understanding Table Hints with Examples – 2
A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.
SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
What does the query optimizer hint ROBUST PLAN do? I explain query hints in simple words and ask you for a practical example of ROBUST PLAN in action.
Adaptive Joins: When the Plan Picks Its Join at Run Time
Understand adaptive joins in SQL Server, read their runtime threshold, inspect the actual choice, and test a query hint safely.