Show TOC

stats_methodLocate this document in the navigation structure

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)