update statistics date for all tables

[Former Member]

Hi Experts

How can update the statistic dates for all tables in SAP

I can easily update by going to detail analysis type the table name

and update the statistic date manually but how can i do it for all tables

regards

PP

[clas_hortien · Accepted solution]

Hi,

just run this script:

use <SID>

exec sp_updatestats

go

This will update all statistics on all tables within the <SID> database.

Regards

Clas

[Former Member]

U can use DB13 for this...