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

DistributionPolicy Enumeration

SQL Server 2014

Represents the distribution Policy enum used on indexes to override DefaultDistributionPolicy.

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

public enum DistributionPolicy

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.
ReplicateREPLICATE: the index will have only ONE segment, and it will be fully replicated on all bricks.
SegmentedHeapIf the table doesn’t have a clustered index, the table property will show value SegmentedHeap.
UndefinedUNDEFINED: One of the reasons is that the DB has been just attached.

Community Additions

© 2015 Microsoft