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.