Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Why use RUNSTAT Utility?

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


Please Help Members By Posting Answers For Below Questions

What is the use of commit in db2?

1073


What is the use of db2?

1051


What is coalesce in db2?

1129


Explain about mirror activator disk mirroring?

1004


What is host variable in db2 cobol?

1074


What does db2 blu stand for?

1165


What is explain in db2?

1012


What language is db2 written in?

1042


How can you find out the # of rows updated after an update statement?

1109


What is difference between isnull and coalesce?

1052


Mention the location where the output received from explain statement is stored.

1124


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?

9189


What is db2 bind process?

1236


What is cobol db2?

994


What is the difference between oracle and db2?

1098