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 value: internal rules determine the update statistics method, as with stats_sample_size
Possible values:
E: estimates
EH: estimates with histograms
EI: estimates with index validation
EX: estimates with histograms and index validation
C: computes
CH: computes with histograms
CI: computes with index validation
CX: computes with histograms and index validation
A: estimates with auto-sample size (DBMS.stats)
AH: estimates with auto-sample size (DBMS.stats) and histograms
AI: estimates with auto-sample size (DBMS.stats) and index validation
AX: estimates with auto-sample size (DBMS.stats) and histograms and index validation
E=: forces estimate for all tables, including tables in DBSTATC control table (option -f method must be set)
C=: forces compute for all tables, including tables in DBSTATC control table (option -f method must be set)
=H: forces creation of histograms for all tables, including tables in DBSTATC control table (option -f method must be set)
=I: forces index validation for all tables, including tables in DBSTATC control table (option -f method must be set)
=X: forces creation of histograms and index validation for all tables, including tables in DBSTATC control table (option -f method must be set)
+H: forces 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: forces 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)