Explain what a plan is?

Answer Posted / bhavna

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the various locks that are available in db2.

612


Give a brief description of db2 isolation levels?

597


How to compare data between two tables in db2?

654


what is db2 restart?

1684


What is database alias db2?

593






What is host variable?

588


What is schema in db2?

572


What is the syntax for creating a table in the db2 database?

623


What is rebind in db2?

571


What is explain in db2?

579


Discuss about db2 bind?

664


What does runstats do in db2?

603


Why do we bind in db2?

621


What is release/acquire in bind?

645


What is a db2 collection?

601