What happens to the PLAN if index used by it is dropped?
Answer Posted / s
The plan is invalidated and an automatic rebind is
attempted next time is the plan is executed.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are db2 objects?
What is dclgen (declaration generator)?
How many databases are there?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is innodb buffer pool?
What is view db2?
What does runstats do in db2?
What is a db2 tablespace?
What is role in db2?
How do I create a view in db2?
What is the physical storage length of time data type?
How connect db2 database to datastage?
What is the difference between using bind () and rebind () methods of naming class?
Why do we use cursor?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?