Interested to Buy Any Domain ? << Click Here >> for more details...
Give some example of statistics collected during RUNSTATS?
- 1 Answers
- 5853 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 are the two types of logging in the db2 database? Explain them.
What are union and union all?
What is query_cache_limit?
What is database alias db2?
What is concurrency?
What is rebind in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to execute stored procedure in db2 command editor?
What is a bind in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
When reorg is used?
What is db2 command?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the clustering index in the db2 database?
Are view updateable?
