Skip to Content
0
Former Member
May 12, 2008 at 09:30 AM

How to delete BIA indexes - manually via program?

407 Views

Dear all

We are currently facing the issue where our BIA indexes are growing at a tremendous rate, due to our use of Full Load and Delete Overlapping Requests activities. Checks shows that our fact indexes are 6999% above the Fact tables and growing by day.

As per suggestion from the SAP Best Practice, we should be deleting and rebuilding the BIA indexes on a regular basis (we plan to do this everytime the loading completes). However, the SAP Best Practice only mention the program to initially activate and fill the BIA indexes (RSDDTREX_BIA_ACTIVATE_FILL), and fail to mention a program to delete the BIA indexes automatically.

Since we are scheduling this activity, is there a program for us to delete the BIA indexes? We will subsequently rebuild it using the RSDDTREX_BIA_ACTIVATE_FILL program.

We don't mind function module as well, as we will create a wrapper program around it.

Thanks for the advise

Chris