database statistics update

[Former Member]

Hi all,

I need to update the update the statistics on table D010TAB , as my SP installation is going very slow . I have tried using DB20 still dowsn't help.

how can i update the statistics of table D010TAB ??

Regads,

Sen

[Former Member]

<removed_by_moderator>

• Do not copy & paste, always quote the source.

Read the "Rules of Engagement"

Edited by: Juan Reyes on Jan 5, 2010 10:19 PM

[JPReyes]

You can use following command,

brconnect -u / -c -f stats -t <name of the table>

http://help.sap.com/saphelp_nw04/Helpdata/EN/88/fce73a86e99c77e10000000a114084/frameset.htm

Regards

Juan

[Former Member]

Hi,

To add to what Juan has mentioned please also check OSS note 554031. That has all the details.

Regards.

Ruchit.