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

Describe major components of db2?

0 Answers  


What is cursor with hold option in db2?

0 Answers  


How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,


What is query_cache_limit?

0 Answers  


How to find schema of a table in db2?

0 Answers  






On the create tablespace, what does the CLOSE parameter do?

1 Answers  


How do you check for a null value in a db2 column?

2 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


What is the role of data manager in the db2 database?

0 Answers  


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?

3 Answers   CTS,


What is the physical storage length of date data type?

0 Answers  


what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,






Categories