What is the logical entity between plan and Package?

Answer Posted / kamal

plan is an optimized access path,but it is an executable component,package contains optimized access path,which is generated by optimizer of bind & it is a non-executable component.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cascading rollback?

853


Which isolation level provides maximum concurrency?

895


What is dbrm library?

788


What do you mean by storage group (stogroup)?

759


How do we specify index to include or not during bind process.

1856


How does db2 sample database connect?

775


Mention some fields that are a part of sqlca.

782


What is explain in db2?

775


Mention the downsides of page level lock.

915


What is ibm db2 database?

723


What is db2 look?

784


What is rct?

974


What is load utility in db2?

883


What is consistency token in db2?

867


What action db2 takes when a program aborts in the middle of a transaction?

873