Skip to Content
0
Former Member
Nov 19, 2012 at 05:42 PM

Improve the speed of creating index for cubes

89 Views

Hi All,

Is there a way to improve the speed of creating index to cubes? I have process chain which does data load to PSA->DSO->cube it takes only 2 minutes to do it while the creation of index takes 10 minutes.

Is it possible to speed up index creation? I know for reporting cube index will speed up the execution other than is it mandatory to do this step delete index and create index in process chain? what if I schedule this step as a sperate process on nightly basis only creating the index.

without deleting index will the load take more time? Let me test it.

Thanks,

Anand