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

what is Runstats? Whem will u choose to runatats?

Answer Posted / s

RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to view db2 table structure?

1016


List out the buffer pools in db2

1073


What are the contents of dclgen?

1112


What are iseries servers?

1075


What is null in db2?

1022


What is sqlca’s maximum length?

1183


What is the role of the data page in the db2 database?

1027


What is db2 plan table?

1048


How many databases can be created inside an instance in db2 ?

1034


Why db2 is called db2?

1038


What is null indicator in cobol db2?

1065


What db2 400?

1188


What is the role of union all and union

1127


Mention the definition of cobol in varchar field.

1249


What kind of database is db2?

1034