Skip to Content
Former Member
Nov 25, 2009 at 05:55 AM

Delete and create Index for DSO


Hi Guys,

In Infocube we drop index before loading( to improve load performance) and then create index after loading to improve read performance.

This is done for Infocube most of the time, but i've not seen this ever done to DSO.

Is there any specific reason for this? ( I think if we are not using DSO for reporting then we needn't drop and creating index.)

can we do the same Drop and create index for DSO if data volume is huge and the drill down detailed report is based on DSO?.

Any insight into this question will be appreciated..