The ALTER PROCEDURE statement enables recompilation of stored procedures without having to execute SHOW PROCEDURE and REPLACE PROCEDURE statements.
This statement provides the following benefits:
- Stored procedures created in earlier database releases can be recompiled to derive the benefits of new features and performance improvements.
- Recompilation is also useful for cross-platform archive and restoration of stored procedures.
- ALTER PROCEDURE allows changes in the following compile-time attributes of a stored procedure: SPL option or Warnings option.