how to stop the update statitics on database level

[Former Member]

Hi experts,

As per the our latest EWA report, SAP has recommanded to OFF the auto_stats_update of the below tables.

Use sp_autostats to turn off auto stats for VBHDR

Use sp_autostats to turn off auto stats for VBDATA

Use sp_autostats to turn off auto stats for VBMOD

urgent answer will be really apprecite.

Thanks

Hemant G

[former_member184473 · Accepted solution]

Hello Hemant,

In the following website you can find the example:

sp_autostats (Transact-SQL)

EXEC sp_autostats '<sid>.VBHDR', 'OFF'
EXEC sp_autostats '<sid>.VBDATA', 'OFF'
EXEC sp_autostats '<sid>.VBHMOD', 'OFF'

Regards,

Eduardo Rezende

[Former Member · Accepted solution]

Hi Eduardo,

Thanks for your help and sorry for delay.

It was really help us.

Regards

Hemant G

[former_member227891]

This message was moderated.