Skip to Content
avatar image
Former Member

Run table statisitics

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 24, 2009 at 02:49 PM

    Afaik DB20 is for Oracle.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Mar 24, 2009 at 04:39 PM

    Crossposting:

    Run table statisitics

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 25, 2009 at 01:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded