Post reply

Building Concurrent Indexes On Same Table

  • September 4, 2018 at 2:26 pm

    #376854

    We move data from our OLTP to our report server for aggregations and reports. The indexes on the OLTP aren't the ones we want on the report server. We drop those and add new ones. Let's say one table needs 4 indexes added. Is it best to break these up into 4 different scripts to run linearly, or can they be in one script?
    Thanks

  • September 4, 2018 at 3:41 pm

    #2004440

    darren.thompson 95578 - Tuesday, September 4, 2018 2:26 PM

    We move data from our OLTP to our report server for aggregations and reports. The indexes on the OLTP aren't the ones we want on the report server. We drop those and add new ones. Let's say one table needs 4 indexes added. Is it best to break these up into 4 different scripts to run linearly, or can they be in one script?
    Thanks

    One script is fine.

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

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