Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
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 |
explain about index with examples
What is dbrm library?
What is meant by repeatable read?
What is schema in db2?
Suppose if I need to update a column, how you do that using cursor?
What do you mean by rollback?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
How can the duplicate values be eliminated from db2 select?
What is a db2 collection?
how do u update the faltfile into db2 table ?
What is the difference between IN subselects and EXISTS subselect?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)