stats_method

This parameter defines the method to be applied to tables that are not specified in the DBSTATC control table for the BRCONNECT update statistics function.

Syntax: stats_method = E|EH|E|EI|EX|C|CH|CI|CX|A|AH|AI|AX|E=|C=|=H|=I|=X|+H|+I

Default: Internal rules determine the update statistics method, as with stats_sample_size

Possible values:

·        E: Estimate

·        EH: Estimate with histograms

·        EI: Estimate with index validation

·        EX: Estimate with histograms and index validation

·        C: Compute

·        CH: Compute with histograms

·        CI: Compute with index validation

·        CX: Compute with histograms and index validation

·        A: Estimate with auto-sample size (DBMS.stats)

·        AH: Estimate with auto-sample size (DBMS.stats) and histograms

·        AI: Estimate with auto-sample size (DBMS.stats) and index validation

·        AX: Estimate with auto-sample size (DBMS.stats) and histograms and index validation

·        E=: Force estimate for all tables, including tables in DBSTATC control table (option -f method must be set)

·        C=: Force compute for all tables, including tables in DBSTATC control table (option -f method must be set)

·        =H: Force creation of histograms for all tables, including tables in DBSTATC control table (option -f method must be set)

·        =I: Force index validation for all tables, including tables in DBSTATC control table (option -f method must be set)

·        =X: Force creation of histograms and index validation for all tables, including tables in DBSTATC control table (option -f method must be set)

·        +H: Force creation of histograms for all tables, including tables in DBSTATC control table in addition in addition to index validation, if defined there (option -f method must be set)

·        +I: Force estimate with index validation for all tables, including tables in DBSTATC control table in addition to creating histograms, if defined there (option -f method must be set)