1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Post New Answer

More DB2 Interview Questions

What is buffrpool? Where we use it ?

2 Answers   Tesco,

What is explain plan in db2?

0 Answers  

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

where can we use index and subscript ? with example ?

3 Answers   CTS,

what is different three logs in DB2?

1 Answers   Syntel,




What is nvl in db2?

0 Answers  

Is Cursor exicutable ?

3 Answers   TetraSoft,

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

What is bind plan?

0 Answers  

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

What is a DB2 access path?

1 Answers  

How to find primary key of a table in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories