Enumeração FragmentationOption
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 (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Enumeration FragmentationOption
'Uso
Dim instance As FragmentationOption
public enum FragmentationOption
public enum class FragmentationOption
type FragmentationOption
public enum FragmentationOption
Membros
| Nome do membro | Descrição | |
|---|---|---|
| Detailed | Value = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005. | |
| Fast | Value = 1. Calculates statistics based on parent level pages only. | |
| Sampled | Value = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005. |
Comentários
The FragmentationOption class are served by the EnumFragmentation method and the GetFragOptionString method.