Post reply

(Rebuild index) or (drop and recreate index)after ETL Fact Load

  • October 27, 2012 at 8:15 am

    #284199

    Hi,

    (Rebuild index after the fact load completed) or (drop index before load starts and recreate index after fact Load ends) ???????

    I would like to know which is good option in terms of faster data load and performance during ETL load.

    Regards,

    Kumar.

  • October 29, 2012 at 9:31 am

    #1553773

    I have found dropping the index before starting and then recreating the index afterwards results in the best overall times for me.

  • November 27, 2012 at 6:50 am

    #1562654

    +1 to Daniel's comment.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply