PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT
IS THE USE OF PACKAGE?
- 2 Answers
- 15379 Views
- Tech Mahindra, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
See there is not doubt that PLAN is an executable form of
DBRM and package is not the executable form.
Basically a DBRM can be linked to PLAN directly or a DBRM
can be linked to Package and that package can further linked
to the PLAN
Now if we directly link the DBRM with the plan then every
time we recompile the program(DBRM) we have to regenerate
the plan.
Whereas if we link the DBRM via package then every time we
recompile the program(DBRM) we only require to recompile the
Package.
Hence Binding through package prevents regeneration of plan.
1 more line I want to add just for knowledge.
If we regenerate the PLAN every time then all the other
Programs(DBRMs) which are attached to that same PLAN
required to be rebind thus take waste time.
Hope this answers your query...
| Is This Answer Correct ? | 27 Yes | 2 No |
What is an alias?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How to resolve deadlock issue
B37 abend during spufi?
What is index cardinality?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is a root page?
What is the difference between db2 and oracle?
What is a cursor in programming?
Which one allows duplicate values Union or Union All ?
What is a clustered index?
COBOL 
