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.