OptimizerHintKind OptimizerHintKind OptimizerHintKind Enum

Definition

Optimizer hints

[Serializable]
public enum OptimizerHintKind
type OptimizerHintKind = 
Public Enum OptimizerHintKind
Inheritance
OptimizerHintKindOptimizerHintKindOptimizerHintKind
Attributes
SerializableAttribute

Fields

AlterColumnPlan AlterColumnPlan AlterColumnPlan 15
BypassOptimizerQueue BypassOptimizerQueue BypassOptimizerQueue 17
CardinalityTunerLimit CardinalityTunerLimit CardinalityTunerLimit 28
CheckConstraintsPlan CheckConstraintsPlan CheckConstraintsPlan 24
ConcatUnion ConcatUnion ConcatUnion 6
ExpandViews ExpandViews ExpandViews 14
Fast Fast Fast 23
ForceOrder ForceOrder ForceOrder 10
HashGroup HashGroup HashGroup 1
HashJoin HashJoin HashJoin 4
HashUnion HashUnion HashUnion 7
IgnoreNonClusteredColumnStoreIndex IgnoreNonClusteredColumnStoreIndex IgnoreNonClusteredColumnStoreIndex 31
KeepFixedPlan KeepFixedPlan KeepFixedPlan 13
KeepPlan KeepPlan KeepPlan 12
KeepUnion KeepUnion KeepUnion 9
LoopJoin LoopJoin LoopJoin 5
MaxDop MaxDop MaxDop 26
MaxGrantPercent MaxGrantPercent MaxGrantPercent 32
MaxRecursion MaxRecursion MaxRecursion 25
MergeJoin MergeJoin MergeJoin 3
MergeUnion MergeUnion MergeUnion 8
MinGrantPercent MinGrantPercent MinGrantPercent 33
NoPerformanceSpool NoPerformanceSpool NoPerformanceSpool 34
OptimizeCorrelatedUnionAll OptimizeCorrelatedUnionAll OptimizeCorrelatedUnionAll 21
OptimizeFor OptimizeFor OptimizeFor 30
OrderGroup OrderGroup OrderGroup 2
ParameterizationForced ParameterizationForced ParameterizationForced 20
ParameterizationSimple ParameterizationSimple ParameterizationSimple 19
QueryTraceOn QueryTraceOn QueryTraceOn 27
Recompile Recompile Recompile 22
RobustPlan RobustPlan RobustPlan 11
ShrinkDBPlan ShrinkDBPlan ShrinkDBPlan 16
TableHints TableHints TableHints 29
Unspecified Unspecified Unspecified 0
UsePlan UsePlan UsePlan 18

Applies to