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

Name the different types of Table spaces.

5 Answers   IBM,


what is consistency token

3 Answers  


What is explain plan in db2?

0 Answers  


List out the data types available.

0 Answers  


What is a dbrm in db2?

0 Answers  






Can any one tell me about Restart logic in DB2.

2 Answers  


1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,


db2 restart logic ?

1 Answers   DELL, HTC, UHG,


Which is faster delete or truncate?

0 Answers  


What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  


What is copy pending and check pending in db2?

0 Answers  


Categories