Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
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|
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....?
What is index cardinality?
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.
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
How do I copy a table in db2?
my project is insurance management system,how to explain my work environment in interview?
What are simple, segmented and partitioned table spaces ?
Explain the use of the WHERE clause?
What will the COMMIT accomplish?
What is meant by AUTO COMMIT?
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.
What is db2 plan table?