Document the tempdb usage by UPDATE STATISTICS - by Linchi Shea

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 483247 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 8/16/2009 6:09:28 PM
Access Restriction Public


UPDATE STATISTICS may use tempdb. But this fact is not documented. Given the importance of the tempdb performance, how tempdb is used by UPDATE STATISTICS should be documented.

Additional info can be found here:
Sign in to post a comment.
Posted by Rick [MSFT] on 4/6/2010 at 12:37 PM
After consulting developers, I added variations of the following sentence to the CREATE STATISTICS, UPDATE STATISTICS, and Capacity Planning for tempdb topics.
CREATE STATISTICS can use tempdb to sort the sample of rows for building
And resolved the bug. Thank you for submitting it.
Posted by alphatross on 8/17/2009 at 5:47 AM
Agree - a one-liner in BOL for the UPDATE STATISTICS syntax would suffice. Even better would be an entry in BOL on what internal operations make use of tempdb.