Export (0) Print
Expand All
Expand Minimize

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

Community Additions

ADD
Show:
© 2014 Microsoft