A question on adding indexes to Rapid Mart fact tables:
I can create the index directly in the database, but will I need to add this elsewhere (in the Rapid_Mart_Data_Model job?) so that it will be rebuilt when $G_REBUILD_INDEXES is set accordingly? Or is there another process for creating new indexes?
SAPIA 4.0 (Rapid Mart), DS 4.0, Oracle 10g
abooth (BOB member since 2011-07-08)
What version of Rapid Marts are you are on? This is already a inbuilt feature.
There should be some flag by name Drop and Rebuild Indexes, just check in the initialization script. Usually Indexes are dropped and rebuilt every week.
If you dont find it there, check it in the Variables List, you will find it there.
I am sure of this.
SantoshNirmala 
(BOB member since 2006-03-15)
Thanks for response - sorry for delay.
Rapid Mart 4.0 (SAP-IA), specifically with table MATERIAL_MVMT_FACT.
There are a number of indexes already, but I need to add another index for the purposes of calculating material in transit (based on PURCH_DOC_ID and PURCH_LINE_ITEM_ID).
I’ve created an index in the database, but it looks like if I inserted records into RM_TABLE_INDEX, the index would be created automatically (and would be rebuilt when $G_REBUILD_INDEXES is set to yes.
Any thoughts or confirmation?
abooth (BOB member since 2011-07-08)