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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to view db2 table structure?

1022


What is netezza database?

1032


What is blu acceleration in db2?

1074


What is a buffer in memory?

1065


Is ibm db2 free?

1015


What are the contents of a dclmgen?

1133


Why do we use cursor?

1106


What are iseries servers?

1079


How can you do the explain of a dynamic sql statement?

1069


Which component is responsible for processing sql statements and selecting access paths?

1134


Is the primary key a clustered index?

1149


Can we insert update delete in view?

973


What is rebind in db2?

1071


What is the maximum No of rows per page?

1071


What happens in bind step in a db2 program?

976