Parameter embedding Optimization PEO
A very interesting subject and here it is post about it very good
https://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options
When PEO is present,
parameters are replaced with literal constant values during query parsing.
https://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options
A point to remember , between others , if you are using OPTION(RECOMPILE) for a statement and expect PEO to happens and don’t , it’s because you assigns to variables and PEO will not be present.
S
Sql Server 