DB2 in the optimization of the stored procedure execution efficiency, for some of the table to add index, index to a stored procedure can't go, I now is: delete the stored procedure rebuilding.
So there are many drawbacks:
1. More than one stored procedure using the table
2. The reconstruction process changed the timestamp stored procedure

Do you have any good method?

CodePudding user response:

You
The rebind

CodePudding user response:

The rebind all