https://ajaydwivedi.com/performance-tuning/procedures-recompile-option/
Procedures with RECOMPILE Option