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 are the various data types available in db2?
Mention data types used in db2 ?
What is the use of predicate?
How do I change the column size in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the use of value function?
What is cascading rollback?
can we view the access paths created by dbrm ? how ? thx
What is the use of db2 optimizer?
Can we delete records from view?
How will you return the number of records in table?
How to retrieve rows from a db2 table in embedded sql?
How to find the number of rows in db2 tables?
what is utility for parm lib
How does cobol compile db2 program?