Specifies the optimizer hints.
命名空间： Microsoft.SqlServer.TransactSql.ScriptDom
程序集： Microsoft.SqlServer.TransactSql.ScriptDom（在 Microsoft.SqlServer.TransactSql.ScriptDom.dll 中）
语法
声明
<SerializableAttribute> _
Public Enumeration OptimizerHintKind
用法
Dim instance As OptimizerHintKind
[SerializableAttribute]
public enum OptimizerHintKind
[SerializableAttribute]
public enum class OptimizerHintKind
[<SerializableAttribute>]
type OptimizerHintKind
public enum OptimizerHintKind
成员
| 成员名称 | 说明 | |
|---|---|---|
| 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. |