Post reply

Update Statistics

  • August 21, 2012 at 5:47 pm

    #280045

    I don't have a clear picture on how update statistics works internally but let's say i perform an update statistics on whole table do i still need to perform update statistics on individual columns in a table...Also let's say i have 5 columns in included column index, Is it advisable to have update statistics of all those columns together???

    Thanks,

    Pradeep

  • August 21, 2012 at 6:28 pm

    #1528414

    What is your setting for sp_autostats ?

    from the help file

    Displays or changes the automatic statistics update option, AUTO_UPDATE_STATISTICS, for an index, a statistics object, a table, or an indexed view.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • August 22, 2012 at 3:27 am

    #1528529

    If you update the statistics for a table, it updates all the statistics associated with that table.

    No, I wouldn't create or maintain individual statistics except in rare cases for tuning queries when you can't add indexes to a table for whatever reason.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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