Explain what a plan is?

Answers were Sorted based on User's Feedback

Explain what a plan is?..

Answer / bhavna

A plan is an executable module containing the access path
produced by DB2 optimizer.

Is This Answer Correct ?    4 Yes 0 No

Explain what a plan is?..

Answer / shashidhar.k.

Plan is load module for SQL statements

Is This Answer Correct ?    3 Yes 3 No

Explain what a plan is?..

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

Post New Answer

More DB2 Interview Questions

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

What is dbrm? When it will be created?

0 Answers  

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

How does cobol compile db2 program?

0 Answers  

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

What is null value in db2?

0 Answers  

Which components manage deadlocks in db2?

0 Answers  

How do you find the maximum value in a column in db2?

0 Answers  

What is usage pointer in cobol?

3 Answers   IBM,

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

What is declare cursor?

0 Answers  

What is a plan and package in db2?

0 Answers