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 view db2 table structure?
What is netezza database?
What is blu acceleration in db2?
What is a buffer in memory?
Is ibm db2 free?
What are the contents of a dclmgen?
Why do we use cursor?
What are iseries servers?
How can you do the explain of a dynamic sql statement?
Which component is responsible for processing sql statements and selecting access paths?
Is the primary key a clustered index?
Can we insert update delete in view?
What is rebind in db2?
What is the maximum No of rows per page?
What happens in bind step in a db2 program?