What is the use of runstats in db2?



What is the use of runstats in db2?..

Answer / Kuldeep Garg

RUNSTATS is a DB2 command used to gather statistics about database objects, such as tables and indexes. These statistics help optimize query performance by providing information for the query optimizer.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

how can u understand the end of the table ?

1 Answers   TCS,


If I have a view which is a join of two or more tables, can this view be updateable?

1 Answers  


What is buffer pool?

1 Answers  


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


What does it mean if the null indicator has -1, 0, -2?

1 Answers  


If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  


Is ibm db2 open source?

1 Answers  


how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


How to create a table using embedded sql?

1 Answers  


Write a query to retrive partial string.

2 Answers  


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


Categories