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 use of commit in db2?
What is the use of db2?
What is coalesce in db2?
Explain about mirror activator disk mirroring?
What is host variable in db2 cobol?
What does db2 blu stand for?
What is explain in db2?
What language is db2 written in?
How can you find out the # of rows updated after an update statement?
What is difference between isnull and coalesce?
Mention the location where the output received from explain statement is stored.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is db2 bind process?
What is cobol db2?
What is the difference between oracle and db2?