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

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

Question Posted / srprev

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

More DB2 Interview Questions

What should be specified along with a cursor in order to continue updating process after commit?

Which are the db2 tools to protect integrity of the database?

What does the CHECK Utility do ?

What is -904 sql code? How to resolve it?

What is sqlca’s maximum length?

What is page size in db2?

I use CS and update a page. Will the lock be released after I am done with that page?

can any body explain about plan and pakage in detail....

How is deadlock resolved?

what is load and unload in db2

What is dclgen (declaration generator)?

How to resolve -818 sql code in DB2?

For more DB2 Interview Questions Click Here