Question:
Dear all,
I'm currently running out of idea on the following problem, please help me!
I got a red warning while performed the Missing Indexes from the tcode DB02, and the result was there is one problem in the ODS (Indexes missing in the database, primary index).
I have read through the oss note 157918 'missing indexes', and i think the solutions was for Infocube.
Please advice.
Thank you.
Regards,
Max
Answer:
Whats the question ???
Answer:
Question:
I got a red warning while performed the Missing Indexes from the tcode DB02, and the result was there is one problem in the ODS (Indexes missing in the database, primary index).
1) Should I create the primary index?
2) Do i have problem if i will not create?
3) Can you list down the steps on creating the ODS primary key?
4) Do we have to drop the index every time we load data into it, and then create index again?
Thank you.
Answer:
If the indexes that are missing inthe database are something like /BIC/E* or BIC/F* then I owuld not be concerned.
Drop Indexes: During creation/load of Aggregates, the secondary indexes of the facttables of the Aggregate cubes should be dropped (note, do NOT drop the secondary indices of the facttables of the Infocube being aggregated). This is because of the high processing power and memory overhead required to maintain these indexes during the load. These indexes should be re-created after the load. Performing this action also ensures that the bitmap indexes remain up to date and do not quickly degenerate (which would result in them taking up more space in the database – see note 304861 for more info on this).
Delete the indexes from the cube --> manage --> performnace tab
Answer:
Steve try running rsrv for your ODS
see if that works
Answer:
Hi Folks ,
How TO REFRESH PRIMARY INDEX FOR AN INFOOBJECT
(Refresh statistics of the table).
I appreciate if any one can throw some light on this
Thanks
Doodle
Answer:
How TO REFRESH PRIMARY INDEX FOR AN INFOOBJECT
transaction DB20 on the infoobject tables directly
Answer:
Hi TFR,
Thanks for the info.
-Doodle