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 |
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is dbrm? When it will be created?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
How does cobol compile db2 program?
what are the SQL codes u freequently got?
What is null value in db2?
Which components manage deadlocks in db2?
How do you find the maximum value in a column in db2?
What is usage pointer in cobol?
what is Runstats? Whem will u choose to runatats?
What is declare cursor?
What is a plan and package in db2?