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 is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

What is node in db2?

What is the logical entity between plan and Package?

How to execute stored procedures?

select distinct(empid),distinct(dept),name from EMP will the above query work?

What are the disadvantages of using VARCHAR?

What is access path in db2?

What are the three DB2 date and time data types and their associated functions?

What is the maximum number of columns in a db2 table?

What is table space in db2?

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

How do you concatenate the firstname and lastname from emp table to give a complete name?

For more DB2 Interview Questions Click Here