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 |
how can u understand the end of the table ?
If I have a view which is a join of two or more tables, can this view be updateable?
What is buffer pool?
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?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
Is ibm db2 open source?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
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?
How to create a table using embedded sql?
Write a query to retrive partial string.
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?