This parameter defines the method to be applied to tables that are not specified in the DBSTATC control table for BRCONNECT update statistics.
stats_method = E|EH|EI|EX|C|CH|CI|CX| A|AH|AI|AX|E=|C=|A=|=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 (locks indexes)
EX: estimates with histograms and index validation (locks indexes)
C: computes
CH: computes with histograms
CI: computes with index validation (locks indexes)
CX: computes with histograms and index validation (locks indexes)
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 (locks indexes)
AX: estimates with auto-sample size (DBMS_stats) and histograms and index validation (locks indexes)
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)
A=: forces estimate with auto-sample size (DBMS_stats) 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 (locks indexes) for all tables, including tables in DBSTATC control table (option -f method must be set)
=X: forces creation of histograms and index validation (locks indexes) 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 index validation (locks indexes) for all tables, including tables in DBSTATC control table in addition to creating histograms, if defined there (option -f method must be set)