#OPTION RECOMPILE STORED PROCEDURE CODE#

When however procedures and triggers are recompiled, any such problems are discovered. drop procedure xspdetails go create procedure xspdetails(address as varchar(50)) WITH RECOMPILE as begin select address,name from xtdetails where addressaddress end. Any existing plan is never reused even if the new plan is exactly the same as any pre-existing plan for that SP. It can not be used at a individual statement level.

#OPTION RECOMPILE STORED PROCEDURE CODE#

If a variable name, that is a keyword in the stored procedure, is wrong, it is unfortunately not recognized during the backup and restore procedure as the compiler does not recognize variable names as such. Now again creating that stored procedure with RECOMPILE option. When used in the code of a particular Stored procedure, Option 1compiles that SP everytime it is executed by any user. v6) and restoring in a newer version, such as InterBase В® 2007 or Firebird 2.1, as Firebird/InterBase В® simply copies the data and metadata into the new version when restoring.

A recompilation would be unnecessary in these cases even if statistics are updated. However, spupdatestats might not cause a recompile, if only one query plan is possible for the tables referenced and the indexes on them. In that new query window, change the name of the.

This function also useful, for example, when backing up an older InterBase В® version (e.g. spupdatestats can trigger a recompile of stored procedures or other compiled code. Right-click on the procedure, select

Option recompile stored procedure