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 |
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
How does coalesce work?
How to rename a table in DB2 ?
Which components manage deadlocks in db2?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What are types of indexes?
What is query for your birthday date should be in hours,minute and seconds format?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is isolation level in db2?
my project is insurance management system,how to explain my work environment in interview?
define clustering index.