SimpleOptimizerHintKind Enumeration

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