OptimizerHintKind 枚举
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
优化器提示
[System.Serializable]
public enum OptimizerHintKind[<System.Serializable>]
type OptimizerHintKind = Public Enum OptimizerHintKind- 继承
-
OptimizerHintKind
- 属性
字段
| 名称 | 值 | 说明 |
|---|---|---|
| Unspecified | 0 | |
| HashGroup | 1 | |
| OrderGroup | 2 | |
| MergeJoin | 3 | |
| HashJoin | 4 | |
| LoopJoin | 5 | |
| ConcatUnion | 6 | |
| HashUnion | 7 | |
| MergeUnion | 8 | |
| KeepUnion | 9 | |
| ForceOrder | 10 | |
| RobustPlan | 11 | |
| KeepPlan | 12 | |
| KeepFixedPlan | 13 | |
| ExpandViews | 14 | |
| AlterColumnPlan | 15 | |
| ShrinkDBPlan | 16 | |
| BypassOptimizerQueue | 17 | |
| UsePlan | 18 | |
| ParameterizationSimple | 19 | |
| ParameterizationForced | 20 | |
| OptimizeCorrelatedUnionAll | 21 | |
| Recompile | 22 | |
| Fast | 23 | |
| CheckConstraintsPlan | 24 | |
| MaxRecursion | 25 | |
| MaxDop | 26 | |
| QueryTraceOn | 27 | |
| CardinalityTunerLimit | 28 | |
| TableHints | 29 | |
| OptimizeFor | 30 | |
| IgnoreNonClusteredColumnStoreIndex | 31 | |
| MaxGrantPercent | 32 | |
| MinGrantPercent | 33 | |
| NoPerformanceSpool | 34 | |
| Label | 35 |