It is attained based on results from RUNSTATS utiliry. The Query Optimizer

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

Question Posted / prajakta

Answer Posted / prajakta

It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to retrieve rows from a db2 table in embedded sql?

1395

Is db2 relational database?

983

What does reorg do in db2?

1035

What is a db2 cursor?

1062

What is bind and rebind in db2?

1139

what is a corelated subquerry?

1123

Mention the downsides of page level lock.

1164

List down the data types in the db2 database.

1128

How do I delete a table in db2?

1081

What is the use of predicate?

1043

What is the reason behind not using select * in embedded sql programs?

1118

What is rebind in db2?

1071

What is a storage group (stogroup)?

1248

How can you classify the locks in db2?

1092

What is the result of open cursor statement?

1083