stored procedures
Haste makes Waste - Stored Procedure Recompilation
Submitted by eherber on Fri, 2008-03-14 11:37. Under: ids | stored procedures | technicalHaste makes Waste - Stored Procedure Recompilation
During the study of the release notes of the new IDS 10.00.FC8 version I noticed a long anticipated feature that already made it into IDS 10.00.FC7:
Enhanced Concurrency after Recompilation of SPL Routines
The problem of locked rows in the dictionary table sysprocplan is something that comes up in many IDS installations that work intensively with stored procedures. The recommendation to reoptimize the stored procedures manually after DDL changes - update statistics for procedure - helps to avoid the problem but is more a kind of a workaround and is often forgotten by the administrator or application developer.



