Skip to Content
Jan 30, 2019 at 03:02 PM

BW process chain flow - optimal performance for cubes



I have a question towards the performance of process chain flows (specific the flow for loading in data for cubes in BW). I'm currently working on a new project towards process chains. I'm now looking into the old flows that already exist and I see 2 differences concerning the data load of cubes.

Flow one that I came across was as followed (this is also the way it was done most of the time): Drop index -> load data -> create index -> DB statistics -> compression.

Second one I came across is: Drop index -> load data -> DB statistics -> compression -> create index.

Could someone explain to me what the difference would be between these two in performance and why it would make a difference, if there is a difference at all.

Kind regards
Sven Swennen