Send the following on WhatsApp
Continue to ChatWhat happens when you use WITH RECOMPILE https://www.scarydba.com/2009/08/21/what-happens-when-you-use-with-recompile/
What happens when you use WITH RECOMPILE https://www.scarydba.com/2009/08/21/what-happens-when-you-use-with-recompile/