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

How to resolve -803 sql code in DB2?

What is a DBRM, PLAN ?

What is meant by isolation level?

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

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

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

What is explain plan in db2?

What are leaf pages?

Could anyone clearly explain the diference between sub query and correlated sub query?

What is a bind in db2?

What are foreign keys in db2?

What is the SQL Communications Area and what are some of its key fields?

For more DB2 Interview Questions Click Here