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 |
What is dbrm library?
What is an instance database?
How is the value function used?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the picture clause of null indicator variable?
What is dynamic SQL?
What is normalization and what are the five normal forms?
What is the latest version of ibm db2?
How can we read records for specific member in CL? AND rpg?
How to find the maximum value in a column in the db2 database?
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?