Question:
Currently, we are maintaining ODS secondary indexes by deleting and recreating them on a weekly basis inorder to avoid the sids corruption. I did not find any sap notes dealing with the primary ODS indexes. How can we maintain the primary indexes of a ODS table. Using se14 transaction, SAP allows to delete and create the primary indexes along with the table deletion and table recreation. Instead of deleting and recreating the primary indexes on the ODS tables, Can we rebuild the ODS primary indexes at the oracle level.
What is the best appoach to maintain the primary indexes of ODS tables.
1. To drop and recreate indexes
2. To rebuild indexes at the oracle level
3. any other approach.
Your input is appreciated,
-Dhara
Answer:
SOME INSIGHTS SIDS
Avoiding SIDs
The creation of SIDs is time-consuming and can be avoided in the following cases:
a) You should not set the indicator for BEx Reporting if you use the ODS object only as a data storage. Otherwise, setting this indicator will have the effect that SIDs are generated for all new characteristic values.
b) If you use line items (for example document number, time stamp and so on) as characteristics in the ODS object, you should mark them as 'Exclusively attribute' in the Characteristics Maintenance.
SOME INSIGHTS INDEXING
1. Indexing
You should use selection criteria for queries on ODS objects. If the key fields are specified, the system uses the existing primary index. The characteristic to which the system accesses frequently should be left-aligned.
However, if the key fields are only incompletely specified in the selection criteria (recognizable in the SQL trace), you can optimize the runtime of the query by creating additional indexes.
You must maintain these
secondary indexes manually in Transaction SE11.
Chetan
nJOY SAP