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 the difference between cursor stability and repeatable read isolation levels?
What are types of indexes?
What os does db2 run on?
How does cobol compile db2 program?
When reorg is used?
What is the use of with ur in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is scrollable cursor in db2?
What is bind in db2?
How do I add a column to a table in db2?
What are packages in db2?
How to find the number of rows in db2 tables?
What does db2 blu stand for?
What is dbrm? When it will be created?
What is explain plan in db2?