SQL Server Performance

How TRUNCATE TABLE effects Statistics?

Discussion in 'SQL Server 2008 General Developer Questions' started by mcprakash, Jul 10, 2009.

  1. mcprakash New Member

    How TRUNCATE TABLE effects Statistics? Is it require to update statistics after trauncate and reload the table?
  2. moh_hassan20 New Member

    yes, you need to update Statistics after truncating table.

  3. mcprakash New Member

    Thanks for the reply.
    Isnt 'Automatically recompute statistics' help to recompute here? Whats its use then?
  4. moh_hassan20 New Member

    TRUNCATE TABLE does not update rowmodctr column in sysindexs which is tracked by autostastics

    from BOL
    If a large amount of data in an indexed column has been added, changed, or removed (that is, if the distribution of key values has changed), or the table has been truncated using the TRUNCATE TABLE statement and then repopulated, use UPDATE STATISTICS.

    have a look to http://msdn.microsoft.com/en-us/library/ms187348(SQL.90).aspx

Share This Page