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

What is db2 catalog database?

558


How can you count the number of rows from a table tab?

608


What is the picture clause of null indicator variable?

669


How do you concatenate the firstname and lastname from emp table to give a complete name?

581


Can there be more than one cursor open for any program?

635






Why db2 is called db2?

577


What types of tables are there in the db2 database?

533


How can we read records for specific member in CL? AND rpg?

214


Can we update view in db2?

535


Mention the various locks that are available in db2.

592


What is db2?

720


Can we delete records from view?

537


What is null in db2?

555


What is dbrm in db2 database?

562


What is iseries database?

581