指定简单优化程序提示类型。
命名空间: Microsoft.Data.Schema.ScriptDom.Sql
程序集: Microsoft.Data.Schema.ScriptDom.Sql(在 Microsoft.Data.Schema.ScriptDom.Sql.dll 中)
语法
声明
<SerializableAttribute> _
Public Enumeration SimpleOptimizerHintKind
[SerializableAttribute]
public enum SimpleOptimizerHintKind
[SerializableAttribute]
public enum class SimpleOptimizerHintKind
[<SerializableAttribute>]
type SimpleOptimizerHintKind
public enum SimpleOptimizerHintKind
成员
| 成员名称 | 说明 | |
|---|---|---|
| Unspecified | 类型为 Unspecified | |
| HashGroup | 类型为 HashGroup | |
| OrderGroup | 类型为 OrderGroup | |
| MergeJoin | 类型为 MergeJoin | |
| HashJoin | 类型为 HashJoin | |
| LoopJoin | 类型为 LoopJoin | |
| ConcatUnion | 类型为 ConcatUnion | |
| HashUnion | 类型为 HashUnion | |
| MergeUnion | 类型为 MergeUnion | |
| KeepUnion | 类型为 KeepUnion | |
| ForceOrder | 类型为 ForceOrder | |
| RobustPlan | 类型为 RobustPlan | |
| KeepPlan | 类型为 KeepPlan | |
| KeepFixedPlan | 类型为 KeepFixedPlan | |
| ExpandViews | 类型为 ExpandViews | |
| AlterColumnPlan | 类型为 AlterColumnPlan | |
| ShrinkDBPlan | 类型为 ShrinkDBPlan | |
| BypassOptimizerQueue | 类型为 BypassOptimizerQueue | |
| UsePlan | 类型为 UsePlan | |
| ParameterizationSimple | 类型为 ParameterizationSimple | |
| ParameterizationForced | 类型为 ParameterizationForced | |
| OptimizeCorrelatedUnionAll | 类型为 OptimizeCorrelatedUnionAll | |
| Recompile | 类型为 Recompile | |
| Fast | 类型为 Fast | |
| CheckConstraintsPlan | 类型为 CheckConstraintsPlan | |
| MaxRecursion | 类型为 MaxRecursion | |
| MaxDop | 类型为 MaxDop | |
| QueryTraceOn | 类型为 QueryTraceOn | |
| CardinalityTunerLimit | 类型为 CardinalityTunerLimit |