OptimizerHintKind Enum

Definition

Optimizer hints

[System.Serializable]
public enum OptimizerHintKind
[<System.Serializable>]
type OptimizerHintKind = 
Public Enum OptimizerHintKind
Inheritance
OptimizerHintKind
Attributes

Fields

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

Applies to