Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     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