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



Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the ..

Answer / vaibhav

Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.

Is This Answer Correct ?    6 Yes 0 No

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the ..

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

Post New Answer

More DB2 Interview Questions

explain about index with examples

2 Answers   Syntel,


What is dbrm library?

0 Answers  


What is meant by repeatable read?

4 Answers  


What is schema in db2?

0 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,






What do you mean by rollback?

0 Answers  


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.

3 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


What is a db2 collection?

0 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,


How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  


Categories