Skip to Content
0
Former Member
Oct 19, 2009 at 07:33 PM

Data laods taking more time to complete

8 Views

Hi,

we have some sale stats cubes which are laoding daily on avg Million records.

We are creating indexes after that then creating aggregates.

Both of these process are taking 2-3 hrs each.. even though we have 0 records in weekends its taking same time toc omplete.

Can anyone suggest us what will be better way to create indexes and roll up data?

Thanks

Sivaprasad