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's The Error Code For Unique Index Voilation?

863


What is the role of the data page in the db2 database?

773


Explain about rct in db2?

866


Why cursor is used in db2?

760


Mention the location where the output received from explain statement is stored.

847


What is the use of db2 optimizer?

817


What is a bind in db2?

768


How is deadlock resolved?

832


what is the sqlcode -501

12102


What is db2 instance?

796


My sql statement select avg(salary) from emp yields inaccurate results. Why?

844


What is database reorganization?

827


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

965


How do you select a row using indexes in db2?

841


What is the usage of open cursor command?

779