Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Secondary Index on a DSO

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

Former Member
Former Member replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question