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