OptimizerHintKind 열거형

Specifies the optimizer hints.

네임스페이스:  Microsoft.SqlServer.TransactSql.ScriptDom
어셈블리:  Microsoft.SqlServer.TransactSql.ScriptDom(Microsoft.SqlServer.TransactSql.ScriptDom.dll)

[SerializableAttribute]
public enum OptimizerHintKind

멤버 이름설명
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.

커뮤니티 추가 항목

추가
표시: