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 function of buffer manager?
How will you delete duplicate records from a table?
Is db2 free?
what is datacom db?
How many databases can be created inside an instance in db2 ?
Explain the contents that are a part of dclgen.
What is check constraint in db2?
How to rename a table in DB2 ?
Can we delete records from view?
wht is d/f between union and joins ?
How to know the primary key of a table without defining the primary key in the table?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures