Explain what a plan is?
Answers were Sorted based on User's Feedback
Answer / bhavna
A plan is an executable module containing the access path
produced by DB2 optimizer.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.
| Is This Answer Correct ? | 1 Yes | 3 No |
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What happens to a cursor after a commit?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is dbrm library?
What is the difference between cursor and select statement?
What is the use of dclgen in db2?
How is a typical db2 batch pgm executed?
Why do chiropractors use drop table?
Define db2 and its databases?
Define buffer pool.
What is image copy in db2?
What is subquery ?