Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,


What is index cardinality?

3 Answers  


Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  


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  


How do I copy a table in db2?

0 Answers  






my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,


What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,


Explain the use of the WHERE clause?

1 Answers  


What will the COMMIT accomplish?

5 Answers  


What is meant by AUTO COMMIT?

3 Answers  


Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  


What is db2 plan table?

0 Answers  






Categories