Plan has the optimized access path in it. But is that
optimized access path is attained or known
Answer / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
|Is This Answer Correct ?||1 Yes||0 No|
What is runstats and reorg in db2?
What is db2 plan table?
what is SPUFI ?
Q4. How will you get the count of record without using COUNT verb in query?
how to execute qcmdexc in rpgle?plz write code also?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
On the create tablespace, what does the CLOSE parameter do?
How to find the number of rows in a db2 table?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
On which levels locks can be applied?
Which catalog table stores referential constraints?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic