Explain what a plan is?

Answer Posted / shashidhar.k.

Plan is load module for SQL statements

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define predicate?

639


Is db2 relational database?

567


How can you quickly find out the # of rows updated after an update statement?

626


What is the use of value function?

617


What does db2 plan contain?

569






What is db2 catalog database?

573


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6808


What are catalog tables in db2?

601


What is the role of union all and union

645


Mention the various locks that are available in db2.

612


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

637


What does reorg do in db2?

572


What is an instance database?

594


Why select is not preferred in embedded sql programs?

705


How can we retrieve the total number of records in RPG & CLLE?

189