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 |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2006-11-10 : 07:42:49
|
| Hi,Does anyone know if UPDATE STATISTICS creates locks the same way as DBCC REINDEX. I am thinking off updating the stats manually of the bigger tables which contain more than a million rows on the weekend in off peak hours. Just wasted to know if I would have to take the system offline? |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-11-10 : 08:35:12
|
| No you can run it when people on there i have done it .... |
 |
|
|
miranwar
Posting Yak Master
125 Posts |
Posted - 2006-11-10 : 09:07:24
|
| Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-10 : 15:23:16
|
| Have a look in BoL at the FULLSCAN option (of UPDATE STATISTICS).We found that the default "portion" of the table that UPDATE STATISTICS was looking at was giving us rubbish query plans and had to move to using FULLSCAN.Takes longer of course ...Kristen |
|
|
|
|
|
|
UPDATE STATISTICS