Skip to Content

Rebuild index of single Table (OS level-Windows)

Hi Experts,

We need to rebuild index of a single table. How to perform this from os level.

Regards

Jithin M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 11, 2013 at 11:41 AM

    you can run SQL command :

    alter index owner."index" rebuild online;

    e.g. : alter index SAPSR3."ARFCRSTATE~0" rebuild online;

    best regards

    ashish

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2013 at 11:56 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2013 at 01:18 PM

    Hi Jithin

    you can run it using the following

    brspace -c force -p initSID.sap -s 20 -l E -f idrebuild -o sapsr3 -i "INDEX_NAME"

    Best Regards

    Marius

    Add comment
    10|10000 characters needed characters exceeded