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
Explain the function of data manager.
What does sqlcabc has?
What is the difference between dbm cfg and db cfg file in db2 ?
What is performance tuning db2?
What is buffer pool in the db2 database?
How do I optimize a query in db2?
How to get the ddl of a table in db2?
How can you classify the locks in db2?
Before you give the explain statement, what are the prerogatives?
What is image copy in db2?
What do you mean by commit and rollback?
Is the primary key a clustered index?
Which is faster delete or truncate?
What is release/acquire in bind?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?