Show TOC Start of Content Area

Syntax documentation stats_change_threshold  Locate the document in its SAP Library structure

This parameter defines the threshold for the percentage of inserted or deleted rows causing an update in optimizer statistics for the BRCONNECT update statistics function.

Syntax: stats_change_threshold = <number>

Default: 50

The value must be greater than zero.

Example

25% means that statistics are collected for a table if either of the following is true:

·         Inserted row count is greater than or equal to 25 % of the old row count

·         Updated row count is greater than or equal to 25 % of the old row count

·         Deleted row count is greater than or equal to 25 / (100*25) % of the old row count

 

End of Content Area