antonio.collins (6/25/2015)
Thanks for the feedback.The dba referenced the cited MSDN blog and correctly points out that ALTER INDEX ALL REBUILD does not update column stats. My counterpoint is that a clustered columnstore index already has column stats and REBUILD updates every relevant stat.
MS has done a good job of making columnstores compatible with existing SQL commands but they're not conventional tables and best practices for conventional tables may not be applicable to columnstores.
Yeah, statistics created automatically won't get updated by the index rebuild. But, rather than take the full scan that was done on the statistics on your index and turn that into a sampled scan, why not just update the column statistics individually? Sure feels like your DBA is attacking the wrong part of the problem. Most column statistics are probably fine with the automatic stats updates anyway. Plus, most column statistics are probably not the driving force behind the filtering on the majority of your queries, but, for sure, the indexes are (or should be).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning