Statistics with index

1. After creating index, there will be a statistics generated.

2. After dropping the index, the statistics will be dropped together. 

When the clustered index of an indexed view is dropped, all nonclustered indexes and auto-created statistics on the same view are automatically dropped. Manually created statistics are not dropped. DROP INDEX (Transact-SQL)

posted on 2013-03-08 10:07  庖丁解牛  阅读(134)  评论(0编辑  收藏  举报