Adam Bean (1/29/2008) Two different SQL Server support techs informed me that issuing a DBCC DBREINDEX, ALTER INDEX REBUILD/REORGANIZE, will NOT update the statistics with fullscan. They recommended having a separate task in our maintenance scripts to update the statistics.
Paul Randal (1/29/2008)
Trust me - I used to own all that code. Reorganize doesn't but rebuild does update stats.
And it's very easy to prove, if you want to see for yourself Adam.
Run DBCC Show_statistics on an index. Check the date the stats were updates. Rebuild the index, then run show statistics again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability