If a table is partitioned, ALTER INDEX REBUILD will only update statistics for that index with default sampling rate. In other words, it is no longer a FULLSCAN. This is documented in http://technet.microsoft.com/en-us/library/ms188388.aspx. But lots of users do not realized that. If you want fullscan, you will need to run UPDATE STATISTCS WITH FULLSCAN. This change was made because we started to support large number of partitions up to 15000 by default.
'SQL Server 2012' 카테고리의 다른 글
SQL Server 2012 Memory (0) | 2013.05.27 |
---|---|
템플릿 매개변수값 설정 바로가기 키 설정 (0) | 2013.04.19 |
Indirect Checkpoint. (0) | 2013.03.20 |
backup database password 옵션 사라졌다~ (sql2012) (0) | 2013.01.16 |
sys.dm_db_stats_properties 통계 속성 (0) | 2013.01.07 |