Post reply

Update Statistics

  • March 18, 2008 at 10:30 am

    #122705

    Do we need to run update statistic command if we create new indexes.

    I am having argument with one of the SQL DBA saying that we still need to run Update Statistics even if we newly created the index.

    Appreciated if someone will throw some idea on that.

    Thanks.

  • March 18, 2008 at 10:36 am

    #790974

    If it is a new index then I dont see why you need to do an Update statistics.

    -Roy

  • March 18, 2008 at 10:49 am

    #790980

    I don't see reason to update statistics for newly created Indexes but for old indexes though not needed I have seen much performance enhancements when executed update statistics tablename with fullscan. I was talking to MS pro., once and he told DBCC DBREINDEX command will actually update a sample of statistics, but not complete statistics.

    SQL DBA.

  • March 18, 2008 at 10:59 am

    #790988

    Thanks guys.

    That is what I have been telling my DBA friend that we don't need update statistics if we have created new index.

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

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