Export (0) Print
Expand All
Expand Minimize

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft