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

What is a data page?

1 Answers  


What is correlation names?

1 Answers  


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


What are the 2 sqlcodes that are returned?

0 Answers  


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


What are leaf pages?

3 Answers  


What is nvl in db2?

0 Answers  


Mention the location where the output received from explain statement is stored.

0 Answers  


Is it possible to precompile if db2 goes down?

4 Answers   Target,


How does DB2 store NULL physically?

2 Answers  


How do you retrieve the data from a nullable column?

2 Answers  


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Categories