Home > DeveloperSection > Interviews > What is RUNSTATS?

Posted on    March-28-2011 7:11 AM

 DB2 DB2 
 1 Answer(s)
  1354  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Posted on    March-28-2011 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick