Secondary Index on a DSO
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
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"