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

What is the difference between db2 and oracle?

685


Which component is responsible for processing sql statements and selecting access paths?

680


Is db2 a database?

578


i want to maintain uniqueness on pdf without make lf??????????

1643


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2332






What is the cobol picture clause of the db2 data types date, time, timestamp?

628


what are bind concepts in db2 cobol?

656


How to find the maximum value in a column in the db2 database?

622


What is the use of predicate?

593


How to find schema of a table in db2?

577


Differentiate between cs and rr isolation levels? Where do you specify them?

592


Explain correlated sub-queries.

593


What is reorg and runstats in db2?

703


How to find the number of rows in db2 tables?

623


What kind of database is db2?

586