stats_change_threshold options

[Former Member]

Generally I use 30 instead of the default 50 for stats_change_threshold. However I want to make threshold smaller for couple tables. when I look at the comments for threshold, it seems that there is option besides a simply number, I ventured to use

stats_change_threshold= (30, TAB:20). Brconnect does not like it. anyone used this before ?

-

---

1. threshold for collecting statistics after checking

2. <threshold> | (<threshold> [, all_part:<threshold>

3. | info_cubes:<threshold> | [<owner>.]<table>:<threshold>

4. | [<owner>.][<prefix>]*[<suffix>]:<threshold>

5. | <tablespace>:<threshold> | <object_list>])

6. default: 50%

7. stats_change_threshold = 50

[fidel_vales · Accepted solution]

Hi,

In addition to the documentation, there are new features (still not in that documentation) that can be found on the notes (which I assume you have not done)

note 892296 indicates:

10. Enhanced syntax of parameter stats_change_threshold
-
(as of Release 7.10 patch  22)
Syntax:
stats_change_threshold = <threshold>
| (<threshold> [, all_part:<threshold> | info_cubes:<threshold>
| [<owner>.]<table>:<threshold>
| [<owner>.][<prefix>]*[<suffix>]:<threshold>
| <tablespace>:<threshold> | <object_list>])
Default: 50%
This new syntax enables you to define different statistical change threshold values for certain tables or table groups.
If, for example, you want to define a lower statistical change threshold value of 30% for the InfoCube tables than the standard value of 50%, which applies for the remaining tables:
stats_change_threshold = (50, info_cubes:30)

1st. you have to check your version

2nd. you have to check the syntax. TAB is not a valid option

3rd. You should be more specific Brconnect does not like it is not clear nor provides any information to help

[Former Member]

Hi Jun,

It is a numeric parameter. Please find the documentation, below;

http://help.sap.com/saphelp_nw70/helpdata/en/02/0ae0c6395911d5992200508b6b8b11/frameset.htm

Best regards,

Orkun Gedik