I had a huge table (more than 160M rows) on SQL2005 EE, and decided to apply a partition scheme.
I've recreated all indexes (clust and non_clust) alligned with table partitioning.
1) if I decide to rebuild one index on a particular partition, does it automatically Update statistics for that index?
I have this question because i know that rebuilding indexes on all partitions triggers the update statistcs, but in this situation i'm not sure of that.
As far as i know index statistics refers to all rows of a table.
2) I've disabled auto_update_statistics: does it mean that i've to "take care" also of column stats that are auto created (_WA_sys_*) ?
Thanks in advance