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 buffer pool in the db2 database?

614


What is consistency token in db2?

640


How do I import data from excel to db2?

610


What is rct?

751


What is meant by dclgen?

618






What is the meaning concurrency in the db2 database?

631


What is null in db2?

571


Explain about mirror activator disk mirroring?

560


What is the role of schema in the db2 database?

649


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

642


What is dbrm? What it contains?

681


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


How to access db2 tables in mainframe?

611


What is difference between isnull and coalesce?

618


What is the maximum length of sqlca?

869