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 |
Define data page.
How to resolve deadlock issue
What is a subselect? Is it different from a nested select?
What is the size of a data page?
What is a clustering index?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
cursor with hold explain ?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What can the Locate option of the Repair Utility accomplish?
Could anyone clearly explain the diference between sub query and correlated sub query?
How is deadlock resolved?
How to create db2 table in mainframe?