What is a DB2 plan?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a DB2 plan?

An application plan or package is generated by the bind to define an access path.
DB2 plan is executable form of sql staements(DBRM).
you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths.

(Continued on next question...)

Other Job Interview Questions

• What is a synonym? How is it used?
• What are aggregate functions?
• How can you quickly find out the # of rows updated after an update statement?
• What is an inner join, and an outer join ?
• How do you eliminate duplicate values in DB2 SELECT ?
• What is the difference between CS and RR isolation levels?
• What is auditing?
• What is a synonym ?
• Can you use MAX on a CHAR column?
• What is REORG? When is it used?
• More...