Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Plan has the optimized access path in it. But is that
optimized access path is attained or known



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

Post New Answer

More DB2 Interview Questions

What is runstats and reorg in db2?

0 Answers  


What is db2 plan table?

0 Answers  


what is SPUFI ?

2 Answers  


Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,






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.

3 Answers  


On the create tablespace, what does the CLOSE parameter do?

1 Answers  


How to find the number of rows in a db2 table?

0 Answers  


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?

3 Answers  


On which levels locks can be applied?

0 Answers  


Which catalog table stores referential constraints?

1 Answers  


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

2 Answers   TCS,






Categories