Give some example of statistics collected during RUNSTATS?
Answer Posted / sadiq afroze
Number of rows in the table, Percent of rows in clustering
sequence, Number of distinct values of indexed column,
Number of rows moved to a nearby/fairway page due to row
length increase
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to find the number of rows in a db2 table?
What is the max length of sqlca?
What is the difference between using bind () and rebind () methods of naming class?
How to execute stored procedures?
What is database alias db2?
Which is faster delete or truncate?
What is a collection in db2?
How do I connect my db2 database to ibm?
What is the difference between cursor and select statement?
Why db2 is called db2?
What is host variable?
List down the types of triggers in the db2 database?
What are iseries servers?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the role of the data page in the db2 database?