What else is there in the PLAN apart from the access path?
Answer / 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 |
How Plan is created while executing the query using SPUFI?
Explain about rct in db2?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is DCLGEN ?
how do u update the faltfile into db2 table ?
What is the physical storage length of time data type?
What does the REORG Utility do?
How can you display the current date & current time ?
what are the SQL codes u freequently got?
How are write I/Os from the buffer pool executed?
how to get duplicate records from tables?write qurey for this?
What is runstats and reorg in db2?