Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DefaultDistributionPolicy Enumeration
Collapse the table of content
Expand the table of content

DefaultDistributionPolicy Enumeration

SQL Server 2014

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)

public enum DefaultDistributionPolicy

Member nameDescription
HashDistribution 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.
NoneNONE: if you specify this option explicitly then there is only one segment which is the entire index.

Community Additions

© 2015 Microsoft