What else is there in the PLAN apart from the access path?
Answer Posted / s
The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is null value in db2?
What is meant by explain?
What is package in cobol db2?
Before you give the explain statement, what are the prerogatives?
What is host variable in db2 cobol?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a db2 collection?
What is buffer pool and list some of them?
What is the use of value function?
what is the role of the cursor in db2?
List some fields from sqlca?
What is the difference between db2 and oracle?
What is alias in db2?
What is difference between alias and synonym in db2?
Mention data types used in db2 ?