What else is there in the PLAN apart from the access path?
Answer / 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 |
What is a cursor and what is its function?
What is dbrm?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
How many databases can be created inside an instance in db2 ?
what is the name of the default db2 catalog database?
What is isolation level in db2?
What is a synonym? How is it used?
What is index in db2?
What is a cursor?
How does the processing of a correlated subquery differ from a non correlated subquery?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?