Interested to Buy Any Domain ? << Click Here >> for more details...
Give some example of statistics collected during RUNSTATS?
- 1 Answers
- 5871 Views
- I also Faced
- E-Mail Answers
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
What is the clustering index in the db2 database?
Mention the definition of cobol in varchar field.
How do we specify index to include or not during bind process.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is multi row fetch in db2?
How to view db2 table structure?
What do you mean by cursor?
How do I add a column to a table in db2?
Define check constraint.
Which isolation level provides highest data integrity?
What is runstats db2?
What is dbrm? What it contains?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How would you find out the total number of rows in a db2 table?
