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 |
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is the difference between using bind () and rebind () methods of naming class?
What is rebind in db2?
Why db2 is called db2?
How do you find the maximum value in a column in db2?
How is a typical DB2 batch program executed ?
What is the difference between spufi and qmf?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
How does the processing of a correlated subquery differ from a non correlated subquery?
How to retrieve rows from a db2 table in embedded sql?