What happens to the PLAN if index used by it is dropped?
- 1 Answers
- 4971 Views
- I also Faced
- E-Mail Answers
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 Utility is used to migrate DB2 from one release to the next?
what is load and unload in db2
What are simple, segmented and partitioned table spaces ?
What is usage pointer in cobol?
When do you specify the isolation level?
What is the use of dclgen in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
When will you chose to run RUNSTATS?
What does DML stand for and what are some examples of it?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is a precompiler?
Explain the contents that are a part of dclgen.
COBOL 
