MS SQL Server - UPDATE STATISTICS Table Full Scan

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]

Author

UPDATE STATISTICS Table Full Scan

Joe K.

2005-07-21, 8:23 pm

How much overhead occurs were SQL Server 2000
executes the followinfg statement:
'UPDATE STATISTICS Table Full Scan'

Does a table lock occur on this database?

Thanks,

Mike Epprecht (SQL MVP)

2005-07-22, 3:23 am

Hi

The Engine makes "Dirty Reads" (a.k.a NOLOCK or SET TRANSACTION ISOLATION
LEVEL READUNCOMMITTED), so there is no locking that is causes.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Joe K." wrote:

>
> How much overhead occurs were SQL Server 2000
> executes the followinfg statement:
> 'UPDATE STATISTICS Table Full Scan'
>
> Does a table lock occur on this database?
>
> Thanks,

Sponsored Links