Export (0) Print
Expand All
Expand Minimize

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)

'Declaration
Public Enumeration FragmentationOption
'Usage
Dim instance As FragmentationOption

Member nameDescription
DetailedValue = 3. Calculates statistics based on 100% of the data. This option is available starting with SQL Server 2005.
FastValue = 1. Calculates statistics based on parent level pages only.
SampledValue = 2. Calculates statistics based on samples of data. This option is available starting with SQL Server 2005.

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

Community Additions

ADD
Show:
© 2014 Microsoft