Skip to Content
0
Former Member
Jan 11, 2010 at 10:30 AM

SE11 Table "VBOX": Can performance of a dictionary table be improved?

683 Views

Hi All,

There is one standard table - VBOX: SD Document: Billing Document: Rebate Index.

In the system it has tons of entries around 4,50,000,00 in our system. There is a requirement to improve its performance.

To my knowledge we generally do this by creating secondary indexes. Here there is already one created by SAP itself through a note. This table doesn't have many fields - only 5 - and all of them are key fields. I checked SAP notes but aren't any related to this table. Thus I would like to know if anyone has has faced this type of issue earlier. I checked this forum and I found entries pertaining to table improvement but most of them suggested to create secondary indexes and use key fields in program etc.

Thus can anyone suggest how can this performance be improved and are there any other features available in SAP to improve a SE11 table performance? Also is it possible to archive the old data - sort of data archiving?

All your views/suggestions are welcome.

Thanks/Regards

Saurabh