Answer Posted / sajjan jindal
IT is a DB2 utility used to collect statistics about the
data values in tables which can be used by the optimizer to
decide the access path. It also collects statistics used
for space management. These statistics are stored in DB2
catalog tables.
The RUNSTAT is executed after a load, or after mass
updates, inserts, deletes, or after REORG.
| Is This Answer Correct ? | 35 Yes | 2 No |
Post New Answer View All Answers
What is consistency token in db2?
What is catalog database in db2?
What is buffer pool?
What are types of indexes?
What is the use of value function?
What is database reorganization?
List out the three types of page locks that can be held.
Outputs of explain are with matchcols = 0. What does this signify?
What is db2 and what is the use of db2 optimizer?
Explain the function of data manager.
What is dclgen in db2?
How is deadlock resolved?
How can you quickly find out the # of rows updated after an update statement?
What is isolation level in db2?
How do I add a column in db2?
