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

Explain db2.

1043


What parameters are used to control the free space in DB2?

1062


What does runstats do in db2?

1128


Which isolation level provides highest data integrity?

1130


How to rename a table in DB2 ?

1096


How to resolve deadlock issue

20158


What is database manager in db2?

1028


What is node in db2?

1051


What is collection in db2 bind?

1022


How can the duplicate values be eliminated from db2 select?

1111


What is runstats db2?

1042


What is universal database?

1074


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1113


What is nvl in db2?

1109


What is bind plan?

1059