asked on

Forced Stored Procedure Recompilation

hi experts, i am reading about Forced Stored Procedure Recompilation, but i do not understand the diference between
WITH RECOMPILE at creation
and
WITH RECOMPILE on execution
with realistic scenarios could explain?
recompile.jpg

RiteshShah

RECOMPILE query hint can beaded to a stored procedure as query hint. This allows only that query (not all) in the stored procedure to recompile. WITH RECOMPILE option recompiles the whole stored procedure which might not be needed/beneficial if the stored procedure has many queries and only some of them need to be recompiled.

http://www.careerride.com/SQL-Server-RECOMPILE-query-hint-and-WITH-RECOMPILE-option.aspx

enrique_aeo

ASKER

my friend, i need more detail...

SOLUTION

RiteshShah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

devlab2012

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial