What is a DB2 plan?

Answer Posted / vira raguram.i

a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a storage group (stogroup)?

775


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1806


How to restart a DB2 program?

1364


Explain how can you do the explain of a dynamic sql statement?

654


What is the use of dclgen in db2?

588






What is reorg?

619


What is load utility in db2?

668


What is collection in db2 bind?

577


What is a buffer in memory?

600


what is db2 restart?

1692


What is difference between isnull and coalesce?

620


What is meant by union and union all?

589


Can we delete records from view?

566


What does reorg do in db2?

578


What is the difference between drop table and delete table?

554