Post reply

SQL Server Index and PE

  • January 30, 2011 at 11:04 am

    #143035

    HI Im working as a SQL DBA where im currently supporting a lage volume of data migration from a legacy system to a brand new product.

    One of the migrations consist of a large volume of data with billions of rows of data in some staging tables. I have a couple of questions here which im hoping the experts can contribute to in terms of performance tuning.

    1)We have created a number of indexes to improve the read time of some queries. However these tables then have large inserts going into them. Does indexing not slow down the insert.

    2)This specific migration is going to be running consecutively for over 24 hours. As a test I did a rebuild and reorganise half way through and this helped. Is this something valid to suggest in production.

    Thanks

  • January 30, 2011 at 2:19 pm

    #1280205

    Please don't cross post.

    Original post can be found here.

    No replies on this thread, please.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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