What happens to the PLAN if index used by it is dropped?
Answer / 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 |
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
cursor with hold explain ?
How could one combine a set of incremental image copies into a single copy?
Discuss about db2 bind?
What are the 4 environments which can access DB2 ?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
Explain the contention situations caused by locks?
what is difference between Static call and Dynamic call? How does it function?
What language is db2 written in?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1