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)