Post reply

rebuild index

  • March 12, 2014 at 10:53 am

    #396410

    We have a SSIS package to export some subset of tables and data in production database to another database on a another server nightly.

    Do we need to reindex all tables after export or not?

    The reindex really takes long for this database, so I would rather not too considering them are exported every night.

    It is truncating the table then import.

    So does that mean when importing to an empty table first time, it will automatically rebuild index.

    Thanks

  • March 12, 2014 at 11:23 am

    #1696494

    Index doesn't get rebuild automatically. To reduce the time you can do index reorg nightly and rebuild once during weekend.

    Or just rebuild indexes for that table.

    You can use this index maintenance solution for that. It'a pretty good one.

    http://ola.hallengren.com/

    --

    SQLBuddy

  • March 12, 2014 at 12:26 pm

    #1696511

    To add to what sqlbuddy has said, check the fragmentation percentage first, if it's quite low, don't bother rebuilding it unless you're seeing some performance degradation because of it. If it's moderately fragmented, perhaps reorganize the index instead of rebuilding it. Of course the terms "low", "moderate", and "high" are different for everyone...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • March 12, 2014 at 1:00 pm

    #1696527

    Because it is daily truncate and import the data, I actually don't want to reindex /reorg if possible. It takes long time.

    I do use maintenance solution of http://ola.hallengren.com/

    for other databases on other servers.

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

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