Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alter Index Rebuild Partition Statistics Question Expand / Collapse
Author
Message
Posted Friday, May 10, 2013 7:57 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:13 PM
Points: 79, Visits: 748
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
Post #1451605
Posted Friday, May 10, 2013 3:29 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:13 PM
Points: 79, Visits: 748
Anyone have thoughts on this? Does SQL Server just retain the statistics that were current prior to the index rebuild for a specific partition?
Post #1451752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse