What is bind plan?



What is bind plan?..

Answer / Khushboo A Risalat

In DB2, a bind plan (or execution plan) is a detailed plan that describes how the optimizer will execute a SQL statement. It includes information about the access method used, join order, and indexes used.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Define sqlca.

1 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


Name the different types of Table spaces.

5 Answers   IBM,


I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


What is the use of predicate?

1 Answers  


What is the use of with ur in db2?

1 Answers  


What is an asychronous write?

1 Answers  


Explain what a plan is?

3 Answers   CTS,


Is ibm db2 free?

1 Answers  


what is the use of cursors?

3 Answers   iGate,


When Can you be sure that a query will return only one row?

4 Answers   IBM,


What is image copy in db2?

1 Answers  


Categories