- You need clarification for which tables the autostats option should be disabled
- Section Tables With Auto Update Statistics Disabled of your Early Watch Report (=EWA) reports that the option autostats is set incorrectly for one or more tables
EWA Report:The AUTOMATIC UPDATE STATISTICS option must be disabled for some tables.
Recommendation: Set the AUTOMATIC UPDATE STATISTICS option to "OFF" for tables VBHDR, VBMOD, and VBDATA as described in SAP Note <note number>
To do so, use SQL command:
EXEC SP_AUTOSTATS <tablename>, OFF
- SAP systems based on SAP NetWeaver with ABAP stack;
- MS SQL Server 2005 and higher;
autostats, SQL Server, disabling, dbacockpit, st04, sap_z_set_parameters, sp_autostats , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW Microsoft SQL Server , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.