Syntax documentationstats_method

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

Syntax Syntax

  1. stats_method = E|EH|EI|EX|C|CH|CI|CX|
  2. A|AH|AI|AX|E=|C=|A=|=H|=I|=X|+H|+I
End of the code.

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)