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 can deadlocks be resolved?
What is db2 and what is the use of db2 optimizer?
What is a db2 tablespace?
What is load replace in db2?
What are the bind parameters ibm db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is ibm db2 client?
Name the various locking levels available?
What is the use of commit in db2?
what is the sqlcode -501
What is the difference between drop table and delete table?
What is the physical storage length of timestamp data type?
What is consistency token in db2?