Question:
Hi BWFans,
which is better strategy for performance on big Infocube (about 80 million records)?
One load is about 1 million of record / week, and rebuild indexes and statistic take too much time......( and often have big problem with tablespaces.....).
Can I have problem If I don't drop indexes before load?
Answer:
??????????
Answer:
More info please.
What source system?
Many transformations? - transfer rules, update rules etc
Any aggregates on the cube?
Are the indexes stock standard, or have extra been created?
Answer:
Source system is R/3
In transfer/update rules there isn't much ABAP and I have three big aggregate on this Infocube.
Thanks in advance