runstats in UDB environment

David Harvey

runstats in UDB environment
Jay/John,

When faced with this problem I also had to remember to change some CFG
values.

There is an excellent discussion on the impact of using the "with
distribution" approach recommended by Jay.

This means you may have to change the values for stat_heap_sz;
num_freqvalues; and num_quantiles.

Refer to Chapter 5 of SC09-2945-01 (Administration Guide: Performance) and
in particular (printed) page 125 where "distribution" is set out in detail
in terms of the impact upon the catalog and thus subsequent access-path
determination.