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

How to get the ddl of a table in db2?

1074


How do I create a view in db2?

976


Which component is responsible for db2 startup and shutdown?

985


Explain about rct.

1026


What is declare cursor?

1046


Is schema the same as database?

1008


What is bind in db2?

979


Is db2 a mainframe database?

946


What's The Percentage Free Space ?

1157


Is db2 relational database?

917


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1005


How does cobol compile db2 program?

1008


What is a storage group (stogroup)?

1189


define clustering index.

980


What are host variables in db2?

993