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|
Describe major components of db2?
What is cursor with hold option in db2?
How can you quickly find out the number of rows updated after an update statement?
What is query_cache_limit?
How to find schema of a table in db2?
On the create tablespace, what does the CLOSE parameter do?
How do you check for a null value in a db2 column?
What can the Locate option of the Repair Utility accomplish?
What is the role of data manager in the db2 database?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is the physical storage length of date data type?
what is the maximum number of tables that can be joined ?