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
What is a system catalog table in db2?
What is the use of predicate?
Which components manage deadlocks in db2?
How do I change the column size in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is meant by explain?
How can you do the explain of a dynamic sql statement?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is runstats and reorg in db2?
What are the contents of a dclmgen?
What is declare cursor?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What does db2 plan contain?
Name the various locking levels available?
What is null indicator in db2?