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...


Give some example of statistics collected during RUNSTATS?



Give some example of statistics collected during RUNSTATS?..

Answer / sadiq afroze

Number of rows in the table, Percent of rows in clustering
sequence, Number of distinct values of indexed column,
Number of rows moved to a nearby/fairway page due to row
length increase

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

Define data page.

0 Answers  


How to resolve deadlock issue

5 Answers   IBM,


What is a subselect? Is it different from a nested select?

1 Answers  


What is the size of a data page?

2 Answers   IBM,


What is a clustering index?

2 Answers  


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


cursor with hold explain ?

1 Answers   Verizon,


How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  


How is deadlock resolved?

0 Answers  


How to create db2 table in mainframe?

0 Answers  


Categories