LiveCache - LC10 message - Index issue

[former_member199694]

hi,

LiveCache - LC10, - Problem Analysis ->Performance -> Database Analyser -> bottleneck report

The message read as follows:

LiveCache- Bottle-neck messages:

2 tables contain > 1.000.000 records but only 20.000 rows will be sampled for statistics.

Table SAPR3./SAPAPO/ORDKEY contains 8247892 rows(205921 pages), sample rows 20000

Table SAPR3./SAPAPO/STOCKANC contains 1319385 rows(25413 pages), sample rows 20000

Looks this would affect the processing and the delay may be an issue for CIF queue processing.

Wondering, if sampling could be increased ? is there any oss note available to do this. This index is implemented using BADI

Any input on this issue is appreciated.

Thanks,

RajS

[Former Member · Accepted solution]

Please check the following notes regarding changing the sample of the statistics run:

Note 808060 - Changing the estimated values for Update Statistics

Note 927882 - FAQ: SAP MaxDB Update Statistics

Kind regards,

Mark

[former_member199694 · Accepted solution]

Thanks Mark !