DistributionPolicy Enumeration
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)
Syntax
public enum DistributionPolicy
public enum class DistributionPolicy
type DistributionPolicy
Public Enumeration DistributionPolicy
Members
Member name | Description | |
---|---|---|
Hash | Distribution 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. |
|
None | NONE: if you specify this option explicitly then there is only one segment which is the entire index. |
|
Replicate | REPLICATE: the index will have only ONE segment, and it will be fully replicated on all bricks. |
|
SegmentedHeap | If the table doesn’t have a clustered index, the table property will show value SegmentedHeap. |
|
Undefined | UNDEFINED: One of the reasons is that the DB has been just attached. |
See Also
Microsoft.SqlServer.Management.Smo Namespace
Return to top