Give some example of statistics collected during RUNSTATS ?
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
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What does the RUNSTATS Utility do? 09.04.08
The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in the DB2 Catalog....What is RUNSTATS ? 17.03.08
A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path. It also collects statisti...Java Garbage Collection Interview Questions 04.11.07
Explain Garbage collection mechanism in Java? Garbage collection is one of the most important features of Java. The purpose of garbage collection is to ident...If an object is garbage collected, can it become reachable again? 01.06.07
Once an object is garbage collected, it ceases to exist. It can no longer become reachable again....Can an object be garbage collected while it is still reachable? 24.05.07
A reachable object cannot be garbage collected. Only unreachable objects may be garbage collected....What are statistics, under what circumstances they go out of date, how do you update them? 15.06.06
Statistics determine the selectivity of the indexes. If an indexed column has unique values then the selectivity of that index is more,...What is the use of ANALYZE command ? 26.03.06
To perform one of these function on an index,table, or cluster: To collect statistics about object used by the optimizer and store them in the data dictionary....Can an object be garbage collected while it is still reachable? 16.03.06
A reachable object cannot be garbage collected. Only unreachable objects may be garbage collected....How do you evaluate performance ? 16.03.06
Using SQL TRACE. It is an utility that can monitor and report on database performance when one or more queries are run against the database. It is used to gath...What is the purpose of finalization? 07.03.06
The purpose of finalization is to give an unreachable object the opportunity to perform any cleanup processing before the object is garbage collected....