Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
culvera
Starting Member
1 Post |
 Posted - 2007-03-08 : 12:48:09
|
| Does a DBCC Reindex update statistics automatically?I have a vendor that issues a DBCC Updatestatistics command separately from their DBCC redindex statements.Is this necessary? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-08 : 13:02:39
|
| DBCC DBREINDEX updates statisticsDBCC INDEXDEFRAG doesn'tCausing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-08 : 13:07:38
|
| I think there is an "edge condition" that gets skipped - can't remember what though. The secondary indexes based on a non-unique clustered index perhaps??Kristen |
|
|
|
|
|
|
UPDATE STATISTICS