Plan has the optimized access path in it. But is that
optimized access path is attained or known
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 |
Post New Answer View All Answers
What is copy pending status in db2?
Why do we bind in db2?
What is the picture clause of null indicator variable?
What is db2 connect?
What does reorg do in db2?
List some fields from sqlca?
Define predicate?
What is check constraint. Explain with example.
What is innodb buffer pool?
What is the function of logging in the db2 database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the role of the data page in the db2 database?
Is db2 a mainframe database?
How can the duplicate values be eliminated from db2 select?
What is the physical storage length of time data type?