FragmentationOption-Enumeration

The FragmentationOption enumeration is a list of constant values that specify the levels of detail of collected fragmentation information.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Enumeration FragmentationOption
'Usage
Dim instance As FragmentationOption

public enum FragmentationOption

public enum class FragmentationOption

type FragmentationOption

public enum FragmentationOption

	Membername	Beschreibung
	Fast	Value = 1. Calculates statistics based on parent level pages only. This option is available starting with SQL Server 2000.
	Sampled	Value = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005.
	Detailed	Value = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.

The FragmentationOption class are served by the EnumFragmentation method and the GetFragOptionString method.