Table of Contents

Class SqlServerHints.Query

Namespace
LinqToDB.DataProvider.SqlServer
Assembly
linq2db.dll
public static class SqlServerHints.Query
Inheritance
SqlServerHints.Query

Fields

ConcatUnion 

public const string ConcatUnion = "CONCAT UNION"

Field Value

string

DisableExternalPushDown 

public const string DisableExternalPushDown = "DISABLE EXTERNALPUSHDOWN"

Field Value

string

DisableScaleOutExecution 

public const string DisableScaleOutExecution = "DISABLE SCALEOUTEXECUTION"

Field Value

string

ExpandViews 

public const string ExpandViews = "EXPAND VIEWS"

Field Value

string

ForceExternalPushDown 

public const string ForceExternalPushDown = "FORCE EXTERNALPUSHDOWN"

Field Value

string

ForceOrder 

public const string ForceOrder = "FORCE ORDER"

Field Value

string

ForceScaleOutExecution 

public const string ForceScaleOutExecution = "FORCE SCALEOUTEXECUTION"

Field Value

string

HashGroup 

public const string HashGroup = "HASH GROUP"

Field Value

string

HashJoin 

public const string HashJoin = "HASH JOIN"

Field Value

string

HashUnion 

public const string HashUnion = "HASH UNION"

Field Value

string

IgnoreNonClusteredColumnStoreIndex 

public const string IgnoreNonClusteredColumnStoreIndex = "IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX"

Field Value

string

KeepFixedPlan 

public const string KeepFixedPlan = "KEEPFIXED PLAN"

Field Value

string

KeepPlan 

public const string KeepPlan = "KEEP PLAN"

Field Value

string

LoopJoin 

public const string LoopJoin = "LOOP JOIN"

Field Value

string

MergeJoin 

public const string MergeJoin = "MERGE JOIN"

Field Value

string

MergeUnion 

public const string MergeUnion = "MERGE UNION"

Field Value

string

NoPerformanceSpool 

public const string NoPerformanceSpool = "NO_PERFORMANCE_SPOOL"

Field Value

string

OptimizeForUnknown 

public const string OptimizeForUnknown = "OPTIMIZE FOR UNKNOWN"

Field Value

string

OrderGroup 

public const string OrderGroup = "ORDER GROUP"

Field Value

string

ParameterizationForced 

public const string ParameterizationForced = "PARAMETERIZATION FORCED"

Field Value

string

ParameterizationSimple 

public const string ParameterizationSimple = "PARAMETERIZATION SIMPLE"

Field Value

string

Recompile 

public const string Recompile = "RECOMPILE"

Field Value

string

RobustPlan 

public const string RobustPlan = "ROBUST PLAN"

Field Value

string

Methods

Fast(int) 

[Sql.Expression("FAST {0}")]
public static string Fast(int value)

Parameters

value int

Returns

string

MaxDop(int) 

[Sql.Expression("MAXDOP {0}")]
public static string MaxDop(int value)

Parameters

value int

Returns

string

MaxGrantPercent(decimal) 

[Sql.Expression("MAX_GRANT_PERCENT={0}")]
public static string MaxGrantPercent(decimal value)

Parameters

value decimal

Returns

string

MaxRecursion(int) 

[Sql.Expression("MAXRECURSION {0}")]
public static string MaxRecursion(int value)

Parameters

value int

Returns

string

MinGrantPercent(decimal) 

[Sql.Expression("MIN_GRANT_PERCENT={0}")]
public static string MinGrantPercent(decimal value)

Parameters

value decimal

Returns

string

OptimizeFor(string) 

[Sql.Expression("OPTIMIZE FOR ({0})")]
public static string OptimizeFor(string value)

Parameters

value string

Returns

string

QueryTraceOn(int) 

[Sql.Expression("QUERYTRACEON {0}")]
public static string QueryTraceOn(int value)

Parameters

value int

Returns

string