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 difference between cursor stability and repeatable read isolation levels?

1175


What are types of indexes?

1074


What os does db2 run on?

986


How does cobol compile db2 program?

1060


When reorg is used?

1129


What is the use of with ur in db2?

1058


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157


What is scrollable cursor in db2?

1055


What is bind in db2?

1044


How do I add a column to a table in db2?

1104


What are packages in db2?

1023


How to find the number of rows in db2 tables?

1073


What does db2 blu stand for?

1165


What is dbrm? When it will be created?

1029


What is explain plan in db2?

996