Database Statistics

[Former Member]

Hello,

Can some one provide me the procedure and process how to do the Database Statistics for COPA tables.

I tried looking for the same in the SDN forum but couldn't found any links.

Thanks in Advance,

Kumar

[lbreddemann]

Hi Kumar,

well, just like you do it for the other tables...

Either via transaction DB20 or use the BRTOOLS.

Schedule a update statistics job in DB13 or call brconnect directly on the command line:

e.g.

brconnect -u / -c -f stats -t COPA

You may have a look into the documentation and this note:

<a href="http://service.sap.com/sap/support/notes/588668">#588668 - FAQ: Database statistics</a>

<a href="http://help.sap.com/saphelp_nw70/helpdata/en/88/fce73a86e99c77e10000000a114084/frameset.htm">SAP Docu: Update Statistics with BRCONNECT</a>

KR Lars