Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: Updateusage vs updatestatistics

    I am unclear on how dbcc updateusage (which fixes entries in sysindexes) differs from update statistics.

    When would you use one vs the other? Are they any downsides to running these (other than a short performance hit?)

    Any clarity my fellow dba's can provide is greatly appreciated!


  2. #2
    Join Date
    Feb 2002
    update statistics updates the statblob column in sysindexes. Used to update statistics so the optimizer choses the most efficient execution plan.

    updateusage updates the rows,used,reserved and dpages columns in sysindexes. This is used to sync space counters - look at sp_spaceused.

    Check your bol.
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts