Hi,
We have one monthly snap_shot fact. It contains 29 months data (120680871records)
every month we have appended the data (4234831 records ). this fact table has 30 dimensions keys, 20 measures fields. every key and measure have one individual NONCLUSTERED indexes
Every month before loading this fact we have dropped the indexes and after data loaded we recreated the indexes.
Draping indexes are taking 0.010 seconds but Rebuild indexes are taking more than 3 hours.
Please suggest us to the essay and fast method for rebuild the indexes for this table.
Thanks,