IndexOptimize
我有一个简单的问题:运行统计更新SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
以避免如下阻塞是否安全?
USE [DBA]
GO
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; -- turn it on
EXECUTE [dbo].[IndexOptimize]
@Databases = 'XYZ',
@FragmentationLow = NULL,
@FragmentationMedium = NULL,
@FragmentationHigh = NULL,
@UpdateStatistics = 'ALL',
@Indexes = 'XYZ.dbo.XYZ',
@StatisticsSample = 30,
@MaxDOP = 8,
@LogToTable = 'Y';
GO
SET TRANSACTION ISOLATION LEVEL READ COMMITTED; -- turn it off