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.


stats_exclude = [<owner>.]<table><[<owner>.]<index>|[<owner>.]<prefix>*

Default: No exclusion, all SAP tables and indexes are processed

info_cubes: Exclude all InfoCube tables from updating statistics

all_part: Exclude all SAP partitioned tables from updating statistics