OptimizerHintKind Enumeration

Specifies the optimizer hints.

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Enumeration OptimizerHintKind
'Usage
Dim instance As OptimizerHintKind

[SerializableAttribute]
public enum OptimizerHintKind

[SerializableAttribute]
public enum class OptimizerHintKind

[<SerializableAttribute>]
type OptimizerHintKind

public enum OptimizerHintKind

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