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


When will you chose to run RUNSTATS?



When will you chose to run RUNSTATS?..

Answer / deepak dada

is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More DB2 Interview Questions

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

0 Answers   MCN Solutions,


Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,


how to take the back up of the DB2 table.

7 Answers  


what is different three logs in DB2?

1 Answers   Syntel,


What is a DBRM, PLAN ?

3 Answers  


Define db2.

0 Answers  


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  


Categories