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


Please Help Members By Posting Answers For Below Questions

Explain the function of data manager.

617


What does sqlcabc has?

613


What is the difference between dbm cfg and db cfg file in db2 ?

978


What is performance tuning db2?

577


What is buffer pool in the db2 database?

590






How do I optimize a query in db2?

585


How to get the ddl of a table in db2?

654


How can you classify the locks in db2?

614


Before you give the explain statement, what are the prerogatives?

558


What is image copy in db2?

546


What do you mean by commit and rollback?

569


Is the primary key a clustered index?

582


Which is faster delete or truncate?

655


What is release/acquire in bind?

629


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2247