harmful statistics???

[Former Member]

Harmful statistics detected error is frequntly occuring on the system

Well deleting them is a temporary solution

Should i create new statistics

Is there any other permanent solution for this???

Help appreciated

[Former Member · Accepted solution]

Hai,

You can remove the Harmful statistics. The reason for this isyou might have statistics for tables or indexes that have statistics, although they should not have these (for example, pool and cluster tables).

Follow the below link to remove the Harmful statistics.

http://help.sap.com/saphelp_nw70/helpdata/EN/b0/a42100eb7ec5478ebf2c846e2912e9/content.htm

To create statistics use report RSANAORA or transaction DB20 to create the statistic for table.

Regards,

Yoganand.V

[Former Member · Accepted solution]

Thanks Yoganand i know how to delete this statistics using BRTools

But whenever i delete them they re-occur again

So deleting them becomes temporary solution

I need some permanent solution for this error

help appreciated

[Former Member · Accepted solution]

Hello,

I partly disagree with Yoganand here.

SAP's opinion about useful and harmful statistics depends on SAP release, on database release, and of course on the table.

A permanent solution will begin by finding out whether these statistics really are harmful for your release.

SAP note 122718 might give you are start.

You may have to delete statistics, or you may have to adjust your DBCHECK, in order not to get further warnings.

regards

Edited by: Joe Bo. on Jan 16, 2009 10:49 AM:

Or you may have to change the rules how statistics will be collected.