When we drop a table do we need to rebind the plan

manju_1999 · New User Joined: 10 Mar 2006 Posts: 8 Location: Mumbai

hi when we drop a table do we need to rebind the plan that was using that table?

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

When you had dropped the table, the plan which refers to that table may be invalidated, so you may have to do a re-bind. But I believe, that if you have given VALIDATE(RUN) during your previous bind( when that table had existed) and Incremental bind may be automatically performed by DB2 to bring the plan back to valid state.