What is a DB2 plan?

An application plan or package is generated by the bind to define an access path.

Showing Answers 1 - 2 of 2 Answers

Narender

  • Aug 29th, 2006
 

DB2 plan is executable form of sql staements(DBRM).

you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths.

  Was this answer useful?  Yes

Ramya

  • Sep 22nd, 2011
 

The optimized access path is called plan.... plan contains multiple packages / access path's. plan is a optimized access

path to extract the data from the tables.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions