TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

OptimizerHintKind Enumeration

 

Applies To: SQL Server 2016 Preview

Specifies the optimizer hints.

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

[SerializableAttribute]
public enum OptimizerHintKind

Member nameDescription
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.

Return to top

Community Additions

ADD
Show:
© 2016 Microsoft