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 database alias db2?
How can we read records for specific member in CL? AND rpg?
Explain in brief how does db2 determine what lock-size to use?
What is the function of logging in the db2 database?
can all users have the privilage to use the sql statement select * (dml)?
What are the rules for db2 programming?
Name the various locking levels available?
Explain how can you do the explain of a dynamic sql statement?
When reorg is used?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Are views updateable?
Name the lockable units in DB2?
What is a page in db2?
can we view the access paths created by dbrm ? how ? thx
How do you find the maximum value in a column in db2?