SQL parameter sniffing sql Stored Procedure cache

https://www.red-gate.com/simple-talk/sql/t-sql-programming/parameter-sniffing/

stored procedure parameter does not update.