Run table statisitics

[Former Member]

Hi all,

I need to run statistics on a single table. We're on ECC5/SQL2000. DB20 says it's not supported on this system. Any ideas?

Samer

[Former Member]

hi samer,

you can run database statistic for singe table using BRTOOLS. You can run via SAPGUI using tcode SM49 or DB13.

- Type SM49

- Choose BRCONNECT

- Use parameter : "-u / -c -f stats -t <table_name>"

Hope this could help.

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

[markus_doehr2]

> you can run database statistic for singe table using BRTOOLS.

He is on SQL Server, not Oracle.

Markus

[Former Member]

Hi Markus, thanks for the reply above

As alaso posted above I did get beneficial answers from peers in "SAP Netweaver Administrator" that I'll try tomorrow in the office and will post the answers here as well. Anyone else has any ideas please let me know.

Thanks,

Samer

[Former Member]

Please see for an answer,

I end up updating the statistics from SQL, running an UPDATE STATISTICS TableName

[Former Member]

Crossposting:

[Former Member]

Afaik DB20 is for Oracle.

[Former Member]

any idea what it is on a sql?

[Former Member]

Hiii

you can go to DB02 and then click on single table statistics

then it will ask for the table name and then anaylze,then you can update statisitcs

Let me know of any issues

Rohit