Export (0) Print
Expand All
Expand Minimize

OptimizerHintKind Enumeration

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
AlterColumnPlanThe Hint is AlterColumnPlan.
BypassOptimizerQueueThe Hint is BypassOptimizerQueue.
CardinalityTunerLimitThe Hint is CardinalityTunerLimit.
CheckConstraintsPlanThe Hint is CheckConstraintsPlan.
ConcatUnionThe Hint is ConcatUnion.
ExpandViewsThe Hint is ExpandViews.
FastThe Hint is Fast.
ForceOrderThe Hint is ForceOrder.
HashGroupThe Hint is HashGroup.
HashJoinThe Hint is HashJoin.
HashUnionThe Hint is HashUnion.
IgnoreNonClusteredColumnStoreIndexThe Hint is IgnoreNonClusteredColumnStoreIndex.
KeepFixedPlanThe Hint is KeepFixedPlan.
KeepPlanThe Hint is KeepPlan.
KeepUnionThe Hint is KeepUnion.
LoopJoinThe Hint is LoopJoin.
MaxDopThe Hint is MaxDop.
MaxRecursionThe Hint is MaxRecursion.
MergeJoinThe Hint is MergeJoin.
MergeUnionThe Hint is MergeUnion.
OptimizeCorrelatedUnionAllThe Hint is OptimizeCorrelatedUnionAll.
OptimizeForThe Hint is OptimizeFor.
OrderGroupThe Hint is OrderGroup.
ParameterizationForcedThe Hint is ParameterizationForced.
ParameterizationSimpleThe Hint is ParameterizationSimple.
QueryTraceOnThe Hint is QueryTraceOn.
RecompileThe Hint is Recompile.
RobustPlanThe Hint is RobustPlan.
ShrinkDBPlanThe Hint is ShrinkDBPlan.
TableHintsThe Hint is TableHints.
UnspecifiedThe Hint is Unspecified.
UsePlanThe Hint is UsePlan.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft