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 / avinash

It provide the summary information about the
characteristics of data available in table, indexes etc.
DB2 records these information into the CATLOG table and use
this information to decide on the access path to data
during the bind process. To obtain the statistics you can
query the catalog table.

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum size of varchar data type in db2?

1084


When reorg is used?

1083


How do I delete a table in db2?

1027


What is db2 look?

985


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

1078


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2181


What is a dbrm in db2?

982


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1038


How to run db2 command in windows?

1158


What is a cursor in programming?

1028


What is a storage group (stogroup)?

1203


What is meant by union and union all?

968


Is db2 a programming language?

1001


Discuss about db2 bind?

1062


What is the use of runstats in db2?

1053