OptimizerHintKind Enumeration
Specifies the optimizer hints.
Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
Syntax
'Declaration
<SerializableAttribute> _
Public Enumeration OptimizerHintKind
'Usage
Dim instance As OptimizerHintKind
[SerializableAttribute]
public enum OptimizerHintKind
[SerializableAttribute]
public enum class OptimizerHintKind
[<SerializableAttribute>]
type OptimizerHintKind
public enum OptimizerHintKind
Members
| Member name | Description | |
|---|---|---|
| AlterColumnPlan | The Hint is AlterColumnPlan. | |
| BypassOptimizerQueue | The Hint is BypassOptimizerQueue. | |
| CardinalityTunerLimit | The Hint is CardinalityTunerLimit. | |
| CheckConstraintsPlan | The Hint is CheckConstraintsPlan. | |
| ConcatUnion | The Hint is ConcatUnion. | |
| ExpandViews | The Hint is ExpandViews. | |
| Fast | The Hint is Fast. | |
| ForceOrder | The Hint is ForceOrder. | |
| HashGroup | The Hint is HashGroup. | |
| HashJoin | The Hint is HashJoin. | |
| HashUnion | The Hint is HashUnion. | |
| IgnoreNonClusteredColumnStoreIndex | The Hint is IgnoreNonClusteredColumnStoreIndex. | |
| KeepFixedPlan | The Hint is KeepFixedPlan. | |
| KeepPlan | The Hint is KeepPlan. | |
| KeepUnion | The Hint is KeepUnion. | |
| LoopJoin | The Hint is LoopJoin. | |
| MaxDop | The Hint is MaxDop. | |
| MaxRecursion | The Hint is MaxRecursion. | |
| MergeJoin | The Hint is MergeJoin. | |
| MergeUnion | The Hint is MergeUnion. | |
| OptimizeCorrelatedUnionAll | The Hint is OptimizeCorrelatedUnionAll. | |
| OptimizeFor | The Hint is OptimizeFor. | |
| OrderGroup | The Hint is OrderGroup. | |
| ParameterizationForced | The Hint is ParameterizationForced. | |
| ParameterizationSimple | The Hint is ParameterizationSimple. | |
| QueryTraceOn | The Hint is QueryTraceOn. | |
| Recompile | The Hint is Recompile. | |
| RobustPlan | The Hint is RobustPlan. | |
| ShrinkDBPlan | The Hint is ShrinkDBPlan. | |
| TableHints | The Hint is TableHints. | |
| Unspecified | The Hint is Unspecified. | |
| UsePlan | The Hint is UsePlan. |