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 |
Define sqlca.
wt is view ? wht r the restrictions for view ?
Name the different types of Table spaces.
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?
What is the use of predicate?
What is the use of with ur in db2?
What is an asychronous write?
Explain what a plan is?
Is ibm db2 free?
what is the use of cursors?
When Can you be sure that a query will return only one row?
What is image copy in db2?