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

What is the use of runstats in db2?

1178


How is the value function used?

1208


How do you concatenate the firstname and lastname from emp table to give a complete name?

1119


What is universal database?

1118


What does runstats do in db2?

1184


What is explain plan in db2?

1050


What is concurrency?

1304


Define db2.

1171


What is the usage of open cursor command?

1144


How do I import data from excel to db2?

1128


What is view db2?

1131


What is null indicator in cobol db2?

1111


What do you mean by between and in? Is between inclusive of specified range values?

1139


How do you eliminate duplicate values in db2?

1266


How do I copy a table in db2?

1055