Recompiling All Stored Procedures

Previous  Index  Next  How To Use

Recompiling all of your stored procedures can be useful to ensure that you haven't deleted any columns. Usually, InterBase dependency tracking should take care of this, but it sometimes happens to fail.

 

Stored Procedures don't use a fixed query plan or something similar, so adding indices or constraints shouldn't influence execution.

 

The Re-compile All Stored Procedures option can be reached via the Schema node or the Stored Procedures node.