Performance issue

[Former Member]

I have created a index for VBRP table. Now i have adjusted and activated the table. Now will it cause any problem in Production? Is there any disadvantages of it?By the way after indexing my report become fast. Any expart comments!!

Redards.

Kaushik

[Former Member]

Hi Kaushik,

This might help you..

[]

[http://help.sap.com/saphelp_470/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm]

Regards,

Purnima.

[valter_oliveira]

After creating an index it's adisable to run optimizer statistics in tcode DB13.

Regards,

Valter Oliveira.

[Former Member]

Hi,

Ok try to prepare a simple report using VBRP tableand check the performance in SE30. Again you compare with another client if you are having where the index is not created for VBRP table and analyze the performance in that which will show you definitely that performance gap.

To my knowledge if you have created the index there might me performance enhancement only rather than any defects.

Hope my answer helps you.

Cheers!!

[ThomasZloch]

Which fields did you create the index for? Just asking because often times performance problems can be solved by using table VBFA instead of creating new indexes e.g. on VBRP fields VGBEL/VGPOS or AUBEL/AUPOS.

Thomas

[Former Member]

Dear Thomas,

the fields are AUBEL/AUPOS.

[Former Member]

thanks