Share via

SimpleOptimizerHintKind Enumeration

  • Article

Specifies the simple optimizer hint kind.

Namespace:  Microsoft.Data.Schema.ScriptDom.Sql
Assembly:  Microsoft.Data.Schema.ScriptDom.Sql (in Microsoft.Data.Schema.ScriptDom.Sql.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Enumeration SimpleOptimizerHintKind

[SerializableAttribute]
public enum SimpleOptimizerHintKind

[SerializableAttribute]
public enum class SimpleOptimizerHintKind

[<SerializableAttribute>]
type SimpleOptimizerHintKind

public enum SimpleOptimizerHintKind

Members

Member name Description
Unspecified Kind is Unspecified
HashGroup Kind is HashGroup
OrderGroup Kind is OrderGroup
MergeJoin Kind is MergeJoin
HashJoin Kind is HashJoin
LoopJoin Kind is LoopJoin
ConcatUnion Kind is ConcatUnion
HashUnion Kind is HashUnion
MergeUnion Kind is MergeUnion
KeepUnion Kind is KeepUnion
ForceOrder Kind is ForceOrder
RobustPlan Kind is RobustPlan
KeepPlan Kind is KeepPlan
KeepFixedPlan Kind is KeepFixedPlan
ExpandViews Kind is ExpandViews
AlterColumnPlan Kind is AlterColumnPlan
ShrinkDBPlan Kind is ShrinkDBPlan
BypassOptimizerQueue Kind is BypassOptimizerQueue
UsePlan Kind is UsePlan
ParameterizationSimple Kind is ParameterizationSimple
ParameterizationForced Kind is ParameterizationForced
OptimizeCorrelatedUnionAll Kind is OptimizeCorrelatedUnionAll
Recompile Kind is Recompile
Fast Kind is Fast
CheckConstraintsPlan Kind is CheckConstraintsPlan
MaxRecursion Kind is MaxRecursion
MaxDop Kind is MaxDop
QueryTraceOn Kind is QueryTraceOn
CardinalityTunerLimit Kind is CardinalityTunerLimit

See Also

Reference

Microsoft.Data.Schema.ScriptDom.Sql Namespace