Performance & Tuningparameter sniffing recompile optionshttps://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options