Post reply

rebuild indexes and statistics n reporting server

  • September 28, 2016 at 11:32 am

    #313584

    Using SQL Server 2014 enterprise edition.

    I rebuild indexes and statistics on my database on the load server daily after data load, before I take a backup and restore this db on reporting server. Do I need to rebuild indexes and statistics on the reporting server again, or does the backup restore takes care of it?

    Thank you in advance.

  • September 28, 2016 at 11:55 am

    #1903739

    A backup is a page level copy of the original, so there is no need to perform another re-index or re-stat after restoring.

    Also, if your reporting database is static after restoration, then you may consider setting it to read only mode, which can offer some query performance benefits.

    ALTER DATABASE [DB] SET READ_ONLY;

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

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

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