Give some example of statistics collected during RUNSTATS?



Give some example of statistics collected during RUNSTATS?..

Answer / 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

More DB2 Interview Questions

What is dbrm library?

0 Answers  


What is an instance database?

0 Answers  


How is the value function used?

0 Answers  


which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  






What is the picture clause of null indicator variable?

0 Answers  


What is dynamic SQL?

1 Answers   ADP,


What is normalization and what are the five normal forms?

1 Answers  


What is the latest version of ibm db2?

0 Answers  


How can we read records for specific member in CL? AND rpg?

0 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


Categories