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


Please Help Members By Posting Answers For Below Questions

How to resolve deadlock issue

18930


Why do chiropractors use drop table?

854


What is reorg and runstats in db2?

919


What is dbrm? What it contains?

889


List out the data types available.

901


How connect db2 database to datastage?

959


What is with ur in db2?

994


What is explain plan in db2?

758


How to check sequence on a table in db2?

788


How do you select a row using indexes in db2?

833


How do I create a view in db2?

772


What action db2 takes when a program aborts in the middle of a transaction?

850


What is the difference between cursor stability and repeatable read isolation levels?

884


is it compulsory commitment control in journal?

2184


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2886