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 is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to restart a DB2 program?
What are iseries servers?
How would you find out the total number of rows in a db2 table?
How many databases are there?
What is innodb buffer pool?
Can there be more than one cursor open for any program?
What does db2 stand for?
What are concurrency issues?
What are the prerogatives?
What is load replace in db2?
Explain about open switch business continuity software?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Is it possible using max on a char column?
What is the use of db2 optimizer?