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 |
When can an insert of a new primary key value threaten referential integrity?
what is the soft code for deadlock ?
Why do we use cursor?
What is meant by index cardinality?
What is a bind card?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is null in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What's The Error Code For Unique Index Voilation?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
List down the types of triggers in the db2 database?
What is schema in db2?