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

Members

	Member name	Description
	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.

Remarks

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace