DefaultDistributionPolicy Enumeration

 

Represents the default distribution policy that will be used when a new table / index is created in the database.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

Syntax

public enum DefaultDistributionPolicy
public enum class DefaultDistributionPolicy
type DefaultDistributionPolicy
Public Enumeration DefaultDistributionPolicy

Members

Member name Description
Hash

Distribution by HASH: Columns that are explicitly specified by using the syntax serve as the keys for a hash function, and this determines which rows go into which segment.

None

NONE: if you specify this option explicitly then there is only one segment which is the entire index.

See Also

Microsoft.SqlServer.Management.Smo Namespace

Return to top