Show TOC

Syntax documentationstats_exclude Locate this document in the navigation structure

This parameter defines the database objects (that is, tables, indexes, and tablespaces) to be excluded from the BRCONNECT update statistics function. You can use this parameter to exclude tables or indexes with exceptional statistics handling from update statistics.

Syntax Syntax

  1. stats_exclude = [<owner>.]<table><[<owner>.]<index>|
  2. [<owner>.][<prefix>]*[<suffix>]|<tablespace>|
  3. ([object_list])|info_cubes|all_part
End of the code.

Default value: no exclusion, all SAP tables and indexes are processed

Possible values:

  • info_cubes: excludes all InfoCube tables from update statistics

  • all_part: excludes all SAP partitioned tables from update statistics