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 |
How do I copy a table in db2?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
Is schema the same as database?
what is SPUFI ?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What does the sqlcode of -818 pertain to?
Explain package in db2 and its advantages?
What is the latest version of ibm db2?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?