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
How to find schema of a table in db2?
What is a db2 schema?
How to check last update on table in db2?
What does db2 stand for?
What is the difference between db2 and oracle?
What is the use of db2 optimizer?
What is dbrm in db2 database?
What is the difference between cursor stability and repeatable read isolation levels?
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 db2 catalog database?
What is difference between isnull and coalesce?
What is precompiler in db2?
Before you give the explain statement, what are the prerogatives?
How can you classify the locks in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?