Using the DISTRIBUTIONS ONLY Option to Suppress Index Information

In HCL OneDB™, 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.

Do not confuse this DISTRIBUTIONS ONLY option with the DROP DISTRIBUTIONS ONLY option of LOW mode, whose syntax and semantics are not supported in MEDIUM or HIGH mode. For information on how to suppress the collection of column distributions, see Using the DROP DISTRIBUTIONS ONLY Option.