GilaMonster (7/18/2013)
Other way around.When an index rebuild is run, the statistics on that index are updated with fullscan as part of the index rebuild process. It's not that the rebuild is triggering an automatic update, it's not. The update is part and parcel of the index rebuild operation.
On larger tables, UPDATE STATISTICS is sampled unless WITH FULLSCAN is specified. The details of what constitutes large and the sample rates are detailed in Books Online.
Gail is right. I must have been thinking about partitioned indexes, and that only applies in SQL Server 2012 anyway. And I was mostly wrong about UPDATE STATISTICS, so please ignore my third point!
John