Interested to Buy Any Domain ? << Click Here >> for more details...
What else is there in the PLAN apart from the access path?
- 1 Answers
- 5172 Views
- I also Faced
- E-Mail Answers
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 the maximum number of columns in a db2 table?
What do you mean by storage group (stogroup)?
What is db2 stogroup?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is null indicator in cobol db2?
Can we delete records from view?
What is a correlated sub query?
Is db2 relational database?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
what is the maximum number of tables that can be joined ?
What are the two types of logging in the db2 database? Explain them.
How can you display the current date & current time ?
COBOL 
