Explain what a plan is?
Answers were Sorted based on User's Feedback
Answer / bhavna
A plan is an executable module containing the access path
produced by DB2 optimizer.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.
Is This Answer Correct ? | 1 Yes | 3 No |
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What is a recovery log?
how to fetch first 100 rows in db2
What is coalesce in db2?
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....?
Describe major components of db2?
What are types of indexes?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is schema in db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is a NULL value? What are the pros and cons of using NULLS?