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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

what is Runstats? Whem will u choose to runatats?

Question Posted / s

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

Explain about rct.

1026

What is package in db2 mainframe?

923

What is the difference between spufi and qmf?

1053

What is db2 instance?

1019

How to find primary key of a table in db2?

1004

What are concurrency issues?

1032

What is phantom read in db2?

1074

What is sqlca’s maximum length?

1104

What are db2 objects?

1003

What is the clustering index in the db2 database?

958

What are the rules for db2 programming?

1043

What is view db2?

1008

How connect db2 database to datastage?

1190

What does sqlcabc has?

996

Give a brief description of db2 isolation levels?

1014