Export (0) Print
Expand All

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)

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

Community Additions

Show:
© 2015 Microsoft