How to delete DSO Index

[#1]

Dear Experts,

We have been extracting Payroll data in to a PAyroll DSO for the past 4 yrs. The DSO is growing in size and a Index table for this DSO seems to be having more data than the DSO itself.

Could you please tell me as to how to delete the Index data which will free up some table space in the BW Server.

We are moving the data from this DSO to a Cube and I am able to delete the Index for this cube in the process chain.

Thanks,

Sai

[Former Member · Accepted solution]

Hi Sainath,

You can include these 2 function modules in a program, and include the program in the process chain in order to create or delete the index.

RSSM_PROCESS_ODS_DROP_INDEXES

RSSM_PROCESS_ODS_CREA_INDEXES

Regards, Federico

[Former Member]

Thanks Federico.

That was helpfull.

Regards,

Sai

[Former Member]

Check the below thread