Interested to Buy Any Domain ? << Click Here >> for more details...
Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
- 2 Answers
- 6896 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhav
Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / mehdee
. Plans are created by BIND command on sysibm.sysplan. To
execute a package, you must 1st include it in the package
list of a PLAN, so they are only executed when the plan in
which they are contained executes.
PACKAGEs are related to a PLAN, and PLANs are related to
a COLLECTION-ID. So when we REBIND a Package we do not need
to BIND REPLACE the Plan.
| Is This Answer Correct ? | 0 Yes | 0 No |
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the difference between plan and package in db2?
What is filter factor?
What does reorg do in db2?
What is usage pointer in cobol?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What are simple, segmented and partitioned table spaces ?
how can u retrieve the data from null values using applicaion program.
What is coalesce in db2?
List out the buffer pools in db2
Q4. How will you get the count of record without using COUNT verb in query?
COBOL 
