09-26-2008 10:56 AM
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
09-26-2008 11:32 AM
After creating an index it's adisable to run optimizer statistics in tcode DB13.
Regards,
Valter Oliveira.
09-26-2008 11:29 AM
09-26-2008 11:32 AM
After creating an index it's adisable to run optimizer statistics in tcode DB13.
Regards,
Valter Oliveira.
09-26-2008 11:39 AM
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!!
09-26-2008 11:43 AM
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
09-26-2008 12:55 PM
09-27-2008 5:07 AM