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 access path in db2?
How do I import a csv file into db2?
How does a cursor work?
What is the role of data manager in the db2 database?
What are the different types of base tables?
How to rename a table in DB2 ?
What is the maximum length of sqlca?
Explain the function of data manager.
What is bufferpool in db2?
How connect db2 database to datastage?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How does cobol compile db2 program?
What db2 400?
On which levels locks can be applied?
What is the maximum No of rows per page?