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?

Answers were Sorted based on User's Feedback



Why use RUNSTAT Utility?..

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

Why use RUNSTAT Utility?..

Answer / elavarasi

to provide statistical info. abt table,tablespace and index

Is This Answer Correct ?    20 Yes 3 No

Why use RUNSTAT Utility?..

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

More DB2 Interview Questions

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


What are the various data types available in db2?

0 Answers  


What is dbrm? What it contains?

0 Answers  


Comment whether the cursor is closed during commit or not.

0 Answers  


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

0 Answers  


How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,


There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,


Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,


What is the role of union all and union

0 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


Where are plans stored?

2 Answers  


Categories