cancel
Showing results for 
Search instead for 
Did you mean: 

rebuild indexes in sap

Former Member
0 Kudos

Dear Experts

When i chk the update optimizer statistics, there are 26 missing indexes, please help me how to rebuild the missing indexes.

regards

varun

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You need to run update statistics either using brtools or sqlplus.If these indexes are missing from database side ,use t-code se14/se11 to recreate these on DB.

Let us know after checking above mentioned points.

Regards,

Gagan Deep Kaushal

JPReyes
Active Contributor
0 Kudos

Completely missunderstood the question, indexes can be rebuilt by using instructions above.

You can also use Brtools to rebuild indexes...

Read,

http://help.sap.com/saphelp_nw70/helpdata/en/75/95536a63b44b4a9e7f278c7d9c2b67/frameset.htm

Regards

Juan

JPReyes
Active Contributor
0 Kudos

You can rebuild statistics using brconnect at OS level,

brconnect -u / -c -f stats -t <tablespace> -f collect -p <number of parallel processes>

Regards

Juan