distribution only?

Hi teachers, I could not understand what is the meaning of "distribution only" in the update statistics statement. Kindly please teach me. Thanks a lot.

ggk517@gmail.com wrote: > Hi teachers, > > I could not understand what is the meaning of "distribution only" in > the update statistics statement. Kindly please teach me. > > Thanks a lot. doing a search for "distributiosn only" on the online techinfo centre yields the following : http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls894.htm?resultof=%22% In Dynamic Server, when you specify the DISTRIBUTIONS ONLY option, you do not update index information. This option does not affect existing index information. Use this option to avoid the examination of index information that can consume considerable processing time. This option does not affect the recalculation of information on tables, such as the number of pages used, the number of rows, and fragment information. UPDATE STATISTICS needs this information to construct accurate column distributions and requires little time and system resources to collect it. have a look at thisonline tool, its great !!! http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp