SAP Database Tables Update Statistics

Improve Query Performance by updating statistics

 

A.   Check Top 25 Largest Tables

1.    DB02 ->Click “DB Analysis” button.

2.    Click “Top n Largest Tables” button.

3.    It shows the top 25 largest tables.

 

B.   Check last updated date for the tables

1.    DB02-> Click “Detail Analysis” button

2.    Input a table name for checking (e.g. mseg), it can be found from Session A.

3.    It shows the last updated date as below screen for the table MSEG.

 

C.   Update the index for the tables

1.    Logon SAP Server and open Query Analyzer as below screen

2.    Select the database “PRD” and input the SQL command as below screen.

       use PRD

       EXEC sp_updatestats

3.   Repeat session B to check the last updated date for some tables.