Compartilhar via


Enumeração OptimizerHintKind

Specifies the optimizer hints.

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

Sintaxe

'Declaração
<SerializableAttribute> _
Public Enumeration OptimizerHintKind
'Uso
Dim instance As OptimizerHintKind
[SerializableAttribute]
public enum OptimizerHintKind
[SerializableAttribute]
public enum class OptimizerHintKind
[<SerializableAttribute>]
type OptimizerHintKind
public enum OptimizerHintKind

Membros

Nome do membro Descrição
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.

Consulte também

Referência

Namespace Microsoft.SqlServer.TransactSql.ScriptDom