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

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  


What is a bind card?

0 Answers  


What is DCLGEN ?

2 Answers  


What is performance tuning db2?

0 Answers  


What are the contents of a dclmgen?

0 Answers  






What is the result of open cursor statement?

0 Answers  


How many types of page locks can be held in db2?

0 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


What is a collection?

3 Answers  


What is a cursor?

2 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


cobol-db2 runjcl please?

2 Answers   DELL,


Categories