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.