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
What is the difference between db2 and oracle?
Which component is responsible for processing sql statements and selecting access paths?
Is db2 a database?
i want to maintain uniqueness on pdf without make lf??????????
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.
What is the cobol picture clause of the db2 data types date, time, timestamp?
what are bind concepts in db2 cobol?
How to find the maximum value in a column in the db2 database?
What is the use of predicate?
How to find schema of a table in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
Explain correlated sub-queries.
What is reorg and runstats in db2?
How to find the number of rows in db2 tables?
What kind of database is db2?