SQL commands to update statistics on VBAK table

[Former Member]

Hi Guys,

Could anyone provide me the SQL commands to update statistics on VBAK table.

Version:

SAP ECC 6.0

Database system MSSQL

Release 9.00.3068

Windows NT

I would appreciate for a quick response.

Thanks in Advance,

Pradeep Srigiri

[Former Member]

DB20 doesn't support MSSQL.

You can go through DB02_MSS, select Single Table Analysis 'VBAK' and from the Indexes table Update Statistics.

[Former Member]

Hi,

its better to schdule check & update stats in db13 so that all the statistics are updated

[JPReyes]

You can update statistics for a table directly from SAP using transactioN DB20

Regards

Juan

[Former Member]

check this out command with different switches and options

http://doc.ddart.net/mssql/sql70/ua-uz_4.htm

UPDATE STATISTICS VBAK ...........

cheers

dEE