What else is there in the PLAN apart from the access path?



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

Post New Answer

More DB2 Interview Questions

What is the function of buffer manager?

1 Answers  


How will you delete duplicate records from a table?

7 Answers   Google,


Is db2 free?

0 Answers  


what is datacom db?

2 Answers   CSC,


How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,






Explain the contents that are a part of dclgen.

0 Answers  


What is check constraint in db2?

0 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


Can we delete records from view?

0 Answers  


wht is d/f between union and joins ?

2 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


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

2 Answers   Accenture,


Categories