|
Home > Archive > MS SQL Server > October 2006 > Update Statistics
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Ranga 2006-10-31, 12:15 am |
| Hello,
SQL 2000, SP4....
Does anyone know if Update statistics <tablename> with fullscan will cause
blocking/locking ? Can users insert/update/query the table while the above is
running ?
Thanks ,
Ranga
| |
| Hilary Cotter 2006-10-31, 12:15 am |
| It does a scan using read uncommitted so there will be minimal locking if
any.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ranga" <Ranga@discussions.microsoft.com> wrote in message
news:0F2C02C7-48F7-437A-8A50- ACE2F1F3FAF2@microso
ft.com...
> Hello,
>
> SQL 2000, SP4....
>
> Does anyone know if Update statistics <tablename> with fullscan will cause
> blocking/locking ? Can users insert/update/query the table while the above
> is
> running ?
>
> Thanks ,
> Ranga
>
>
| |
| Leo Giakoumakis [MS] 2006-10-31, 12:15 am |
| UPDATE STATISTICS should only take schema modification locks. That will
prevent dropping the table/index during a stats update.
Regular statements should not block while statistics are being updated.
Regards,
Leo
"Ranga" <Ranga@discussions.microsoft.com> wrote in message
news:0F2C02C7-48F7-437A-8A50- ACE2F1F3FAF2@microso
ft.com...
> Hello,
>
> SQL 2000, SP4....
>
> Does anyone know if Update statistics <tablename> with fullscan will cause
> blocking/locking ? Can users insert/update/query the table while the above
> is
> running ?
>
> Thanks ,
> Ranga
>
>
| |
| Ranga 2006-10-31, 12:15 am |
| Thank you very much for your replies.
"Leo Giakoumakis [MS]" wrote:
> UPDATE STATISTICS should only take schema modification locks. That will
> prevent dropping the table/index during a stats update.
>
> Regular statements should not block while statistics are being updated.
>
> Regards,
>
> Leo
>
>
> "Ranga" <Ranga@discussions.microsoft.com> wrote in message
> news:0F2C02C7-48F7-437A-8A50- ACE2F1F3FAF2@microso
ft.com...
>
>
>
|
|
|
|
|