What happens to the PLAN if index used by it is dropped?
- 1 Answers
- 4976 Views
- I also Faced
- E-Mail Answers
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
Can we delete records from view?
What is the difference between using bind () and rebind () methods of naming class?
Can we insert update delete in view?
What is reorg?
Explain package in db2 and its advantages?
What is the maximum No of rows per page?
What is db2 and what is the use of db2 optimizer?
What is nvl in db2?
What is table space in db2?
Which component is responsible for db2 startup and shutdown?
How to access db2 tables in mainframe?
How is deadlock resolved?
How do I start db2 in windows?
What is a db2 schema?
When do you specify the isolation level?
