locked
HOW TO CREATE THE INDEXES FOR HUGE DATA SNAPSHOT TABLE RRS feed

  • Question

  •  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,


        
    • Edited by sheshu0022 Friday, October 5, 2018 7:07 PM
    Friday, October 5, 2018 7:04 PM

Answers

All replies