topic Re: Performance issue in Application Development and Automation Discussions

Performance issue

Former Member — Fri, 26 Sep 2008 09:56:57 GMT

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

Re: Performance issue

Former Member — Fri, 26 Sep 2008 10:29:36 GMT

Hi Kaushik,

This might help you..

[]

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

Regards,

Purnima.

Re: Performance issue

valter_oliveira — Fri, 26 Sep 2008 10:32:14 GMT

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

Regards,

Valter Oliveira.

Re: Performance issue

Former Member — Fri, 26 Sep 2008 10:39:42 GMT

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!!

Re: Performance issue

ThomasZloch — Fri, 26 Sep 2008 10:43:19 GMT

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

Re: Performance issue

Former Member — Fri, 26 Sep 2008 11:55:06 GMT

Dear Thomas,

the fields are AUBEL/AUPOS.

Re: Performance issue

Former Member — Sat, 27 Sep 2008 04:07:27 GMT

thanks