Explain what a plan is?

Question Posted / guest

3 Answers
8770 Views
CTS, I also Faced
E-Mail Answers

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

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers

What is the latest version of ibm db2?

0 Answers

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers IBM,

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers

How can you display the current date & current time ?

7 Answers Cap Gemini,

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers Logica CMG,

What is the clustering index in the db2 database?

0 Answers

what is a corelated subquerry?

0 Answers IBM,

What is an inner join, and an outer join ?

1 Answers CTA,

What is bufferpool in db2?

0 Answers

max number of columns in a db2 table?

6 Answers

For more DB2 Interview Questions Click Here