Show TOC

stats_specialLocate this document in the navigation structure

This parameter lets you emulate the table DBSTATC if you want to run update statistics in a Java database, in which the table DBSTATC does not exist. You can use stats_special to specify tables that need special handling.

stats_special = (<table>:[<owner>]:<active>:[<method>]:[<sample>], ...)

Possible values:

  • <table>: table name

  • <owner>: table owner (optional)

  • <active>: active indicator:

    • A: active (automatic check and possibly analysis) (default)

    • I: ignore (no automatic check and analysis)

    • N: negative (statistics are deleted)

    • U: forced (analysis is always performed, without check)

    • P: priority (same as "A", but execution occurs earlier)

    • R: restrictive - special handling for fix statistics, as described in SAP Note 1020260 Information published on SAP site

  • <method>: method of analysis:

    • E: estimates statistics (default)

    • EH: estimates statistics and generates histograms

    • EI: estimates statistics and structure validation of indices (locks indexes)

    • EX: estimates statistics and histograms and index validation (locks indexes)

    • C: computes statistics exactly

    • CH: computes statistics exactly and generate histograms

    • CI: computes statistics exactly and structure validation of indices (locks indexes)

    • CX: computes statistics exactly and histograms and index validation (locks indexes)

    • A: estimates statistics with auto sample size

    • AH: statistics with auto sample size and generate histograms

    • AI: statistics with auto sample and structure validation of indices (locks indexes)

    • AX: statistics with auto sample and histograms and index validation (locks indexes)

  • <sample>: sample size for analysis methods E, EH, EI, and EX

    • P<n>: <n> percentage of total number of table rows (from 1 to 100 and from .001 to .999)

    • P<n>: <n> thousand table rows

Example

stats_special = (SDBAD::A:E:P15, SDBAH::A:E:R2)

For more information, see the description of the DBSTATC table in the ABAP Dictionary (transaction SE11).