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
What is commit in db2?
How to connect to db2 database from windows command line?
What is the difference between cursor and select statement?
What does db2 plan contain?
What is db2 look?
What is query_cache_limit?
Explain the contents that are a part of dclgen.
Why db2 is called db2?
What is the use of predicate?
Which are the db2 tools to protect integrity of the database?
What is check constraint in db2?
How do I optimize a query in db2?
What is coalesce in db2?
What is cursor in dbms?
Explain db2.