Secondary Index on a DSO

[Former Member]

Hi,

I have to create 3 different secondary index on a DSO as that DSO is being used in various start routines for a select statement.

Do i need to regularly fill/refresh the secondary indexes after each data load if so can you please update me how to refresh or fill the secondary index on a dso

Thanks

[RamanKorrapati · Accepted solution]

Hi,

Performance wise, like cube we need to drop and recreate index on DSO as well thru process chains. here we need to use below  function Modules.

To created index - RSSM_PROCESS_ODS_CREA_INDEXES

To delete index - RSSM_PROCESS_ODS_DROP_INDEXES.

We need to use custom type or abap program(developed by using above FM) process type in process chains.

based on that we can use above FM to delete and create indexes on DSO.

For more please Google it.

Use search key as " How to Create Secondary Index on DSO’s"

Thanks

[Former Member]

Hello

you dont need to manually maintain the secondary index. It is adjusted automatically during the loading process. secondary indexes increase the load time so be sure to create for only those you need.