Post reply

Alter Index Rebuild Partition Statistics Question

  • May 10, 2013 at 7:57 am

    #293771

    Hi all,

    I have a question regarding what happens to statistics when an index is rebuilt for a specific partition. I understand that in general, when you rebuild an index, you get the equivalent of a fullscan (at least in 2008, not sure if this has changed in 2012). My question is: How does this apply when an index is rebuilt for a partition since statistics are maintained at the table level and not at the partition level?

    Thanks!

    Adam

  • May 10, 2013 at 3:29 pm

    #1614323

    Anyone have thoughts on this? Does SQL Server just retain the statistics that were current prior to the index rebuild for a specific partition?

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

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